{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " Fichier permettant de créer une base de comparanson pandas entre Simtax_py et Simtax_fortran"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import simtax\n",
    "import pandas as pd\n",
    "person = simtax.person\n",
    "hhold = simtax.hhold\n",
    "tax = simtax.tax"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Importation des outputs de Fortran"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "path = !pwd\n",
    "path = path[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "simtax_fortran_out = pd.read_csv(path+'/version_fortran/SimTax/test_output_file.txt', delimiter=',' )\n",
    "simtax_fortran_out=simtax_fortran_out.rename(columns = {' age':'age'})\n",
    "simtax_fortran_out=round(simtax_fortran_out)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>inc_earning</th>\n",
       "      <th>inc_CPP_pension</th>\n",
       "      <th>inc_private_pension</th>\n",
       "      <th>ind_disp_inc</th>\n",
       "      <th>prov_inc_tax</th>\n",
       "      <th>fed_inc_tax</th>\n",
       "      <th>QC_NET_inc</th>\n",
       "      <th>QC_Taxable_Inc</th>\n",
       "      <th>OAS_inc</th>\n",
       "      <th>GIS_inc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20759.0</td>\n",
       "      <td>1238.0</td>\n",
       "      <td>1341.0</td>\n",
       "      <td>23870.0</td>\n",
       "      <td>23870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36264.0</td>\n",
       "      <td>5768.0</td>\n",
       "      <td>4457.0</td>\n",
       "      <td>48870.0</td>\n",
       "      <td>48870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51643.0</td>\n",
       "      <td>10768.0</td>\n",
       "      <td>8687.0</td>\n",
       "      <td>73870.0</td>\n",
       "      <td>73870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66367.0</td>\n",
       "      <td>16332.0</td>\n",
       "      <td>13400.0</td>\n",
       "      <td>98870.0</td>\n",
       "      <td>98870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79577.0</td>\n",
       "      <td>22695.0</td>\n",
       "      <td>18828.0</td>\n",
       "      <td>123870.0</td>\n",
       "      <td>123870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22546.0</td>\n",
       "      <td>1638.0</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>26370.0</td>\n",
       "      <td>26370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37837.0</td>\n",
       "      <td>6268.0</td>\n",
       "      <td>4885.0</td>\n",
       "      <td>51370.0</td>\n",
       "      <td>51370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53215.0</td>\n",
       "      <td>11268.0</td>\n",
       "      <td>9115.0</td>\n",
       "      <td>76370.0</td>\n",
       "      <td>76370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67724.0</td>\n",
       "      <td>16932.0</td>\n",
       "      <td>13943.0</td>\n",
       "      <td>101370.0</td>\n",
       "      <td>101370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80890.0</td>\n",
       "      <td>23338.0</td>\n",
       "      <td>19370.0</td>\n",
       "      <td>126370.0</td>\n",
       "      <td>126370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24333.0</td>\n",
       "      <td>2038.0</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>28870.0</td>\n",
       "      <td>28870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39409.0</td>\n",
       "      <td>6768.0</td>\n",
       "      <td>5313.0</td>\n",
       "      <td>53870.0</td>\n",
       "      <td>53870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54787.0</td>\n",
       "      <td>11768.0</td>\n",
       "      <td>9543.0</td>\n",
       "      <td>78870.0</td>\n",
       "      <td>78870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69069.0</td>\n",
       "      <td>17545.0</td>\n",
       "      <td>14486.0</td>\n",
       "      <td>103870.0</td>\n",
       "      <td>103870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82204.0</td>\n",
       "      <td>23982.0</td>\n",
       "      <td>19913.0</td>\n",
       "      <td>128870.0</td>\n",
       "      <td>128870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26120.0</td>\n",
       "      <td>2438.0</td>\n",
       "      <td>2280.0</td>\n",
       "      <td>31370.0</td>\n",
       "      <td>31370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40981.0</td>\n",
       "      <td>7268.0</td>\n",
       "      <td>5741.0</td>\n",
       "      <td>56370.0</td>\n",
       "      <td>56370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56359.0</td>\n",
       "      <td>12268.0</td>\n",
       "      <td>9971.0</td>\n",
       "      <td>81370.0</td>\n",
       "      <td>81370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70382.0</td>\n",
       "      <td>18188.0</td>\n",
       "      <td>15028.0</td>\n",
       "      <td>106370.0</td>\n",
       "      <td>106370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83517.0</td>\n",
       "      <td>24626.0</td>\n",
       "      <td>20456.0</td>\n",
       "      <td>131370.0</td>\n",
       "      <td>131370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27862.0</td>\n",
       "      <td>2883.0</td>\n",
       "      <td>2593.0</td>\n",
       "      <td>33870.0</td>\n",
       "      <td>33870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42553.0</td>\n",
       "      <td>7768.0</td>\n",
       "      <td>6169.0</td>\n",
       "      <td>58870.0</td>\n",
       "      <td>58870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57931.0</td>\n",
       "      <td>12768.0</td>\n",
       "      <td>10399.0</td>\n",
       "      <td>83870.0</td>\n",
       "      <td>83870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71696.0</td>\n",
       "      <td>18832.0</td>\n",
       "      <td>15571.0</td>\n",
       "      <td>108870.0</td>\n",
       "      <td>108870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84831.0</td>\n",
       "      <td>25270.0</td>\n",
       "      <td>20999.0</td>\n",
       "      <td>133870.0</td>\n",
       "      <td>133870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>84559.0</td>\n",
       "      <td>23187.0</td>\n",
       "      <td>19754.0</td>\n",
       "      <td>127500.0</td>\n",
       "      <td>127500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>95682.0</td>\n",
       "      <td>30025.0</td>\n",
       "      <td>25131.0</td>\n",
       "      <td>151370.0</td>\n",
       "      <td>151370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>106265.0</td>\n",
       "      <td>36771.0</td>\n",
       "      <td>30954.0</td>\n",
       "      <td>176370.0</td>\n",
       "      <td>176370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>118348.0</td>\n",
       "      <td>43209.0</td>\n",
       "      <td>37042.0</td>\n",
       "      <td>201370.0</td>\n",
       "      <td>201370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>130022.0</td>\n",
       "      <td>49646.0</td>\n",
       "      <td>43931.0</td>\n",
       "      <td>226370.0</td>\n",
       "      <td>226370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>141696.0</td>\n",
       "      <td>56084.0</td>\n",
       "      <td>50819.0</td>\n",
       "      <td>251370.0</td>\n",
       "      <td>251370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>85872.0</td>\n",
       "      <td>23831.0</td>\n",
       "      <td>20297.0</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>96833.0</td>\n",
       "      <td>30769.0</td>\n",
       "      <td>25737.0</td>\n",
       "      <td>153870.0</td>\n",
       "      <td>153870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>107516.0</td>\n",
       "      <td>37415.0</td>\n",
       "      <td>31559.0</td>\n",
       "      <td>178870.0</td>\n",
       "      <td>178870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>119516.0</td>\n",
       "      <td>43853.0</td>\n",
       "      <td>37731.0</td>\n",
       "      <td>203870.0</td>\n",
       "      <td>203870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>131189.0</td>\n",
       "      <td>50290.0</td>\n",
       "      <td>44619.0</td>\n",
       "      <td>228870.0</td>\n",
       "      <td>228870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>142863.0</td>\n",
       "      <td>56728.0</td>\n",
       "      <td>51508.0</td>\n",
       "      <td>253870.0</td>\n",
       "      <td>253870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>87186.0</td>\n",
       "      <td>24475.0</td>\n",
       "      <td>20839.0</td>\n",
       "      <td>132500.0</td>\n",
       "      <td>132500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>97984.0</td>\n",
       "      <td>31512.0</td>\n",
       "      <td>26342.0</td>\n",
       "      <td>156370.0</td>\n",
       "      <td>156370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>108767.0</td>\n",
       "      <td>38059.0</td>\n",
       "      <td>32164.0</td>\n",
       "      <td>181370.0</td>\n",
       "      <td>181370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>120683.0</td>\n",
       "      <td>44496.0</td>\n",
       "      <td>38420.0</td>\n",
       "      <td>206370.0</td>\n",
       "      <td>206370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>132357.0</td>\n",
       "      <td>50934.0</td>\n",
       "      <td>45308.0</td>\n",
       "      <td>231370.0</td>\n",
       "      <td>231370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>144031.0</td>\n",
       "      <td>57371.0</td>\n",
       "      <td>52197.0</td>\n",
       "      <td>256370.0</td>\n",
       "      <td>256370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>88463.0</td>\n",
       "      <td>25155.0</td>\n",
       "      <td>21382.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>99135.0</td>\n",
       "      <td>32256.0</td>\n",
       "      <td>26947.0</td>\n",
       "      <td>158870.0</td>\n",
       "      <td>158870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>110018.0</td>\n",
       "      <td>38703.0</td>\n",
       "      <td>32770.0</td>\n",
       "      <td>183870.0</td>\n",
       "      <td>183870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>121850.0</td>\n",
       "      <td>45140.0</td>\n",
       "      <td>39108.0</td>\n",
       "      <td>208870.0</td>\n",
       "      <td>208870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>133524.0</td>\n",
       "      <td>51578.0</td>\n",
       "      <td>45997.0</td>\n",
       "      <td>233870.0</td>\n",
       "      <td>233870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>145198.0</td>\n",
       "      <td>58015.0</td>\n",
       "      <td>52886.0</td>\n",
       "      <td>258870.0</td>\n",
       "      <td>258870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>89677.0</td>\n",
       "      <td>25899.0</td>\n",
       "      <td>21925.0</td>\n",
       "      <td>137500.0</td>\n",
       "      <td>137500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>100376.0</td>\n",
       "      <td>32909.0</td>\n",
       "      <td>27553.0</td>\n",
       "      <td>161370.0</td>\n",
       "      <td>161370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>111268.0</td>\n",
       "      <td>39346.0</td>\n",
       "      <td>33375.0</td>\n",
       "      <td>186370.0</td>\n",
       "      <td>186370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>123018.0</td>\n",
       "      <td>45784.0</td>\n",
       "      <td>39797.0</td>\n",
       "      <td>211370.0</td>\n",
       "      <td>211370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>134692.0</td>\n",
       "      <td>52221.0</td>\n",
       "      <td>46686.0</td>\n",
       "      <td>236370.0</td>\n",
       "      <td>236370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>146365.0</td>\n",
       "      <td>58659.0</td>\n",
       "      <td>53575.0</td>\n",
       "      <td>261370.0</td>\n",
       "      <td>261370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>432 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     age  inc_earning  inc_CPP_pension  inc_private_pension  ind_disp_inc  \\\n",
       "0     60          0.0              0.0                  0.0        7956.0   \n",
       "1     60      25000.0              0.0                  0.0       20759.0   \n",
       "2     60      50000.0              0.0                  0.0       36264.0   \n",
       "3     60      75000.0              0.0                  0.0       51643.0   \n",
       "4     60     100000.0              0.0                  0.0       66367.0   \n",
       "5     60     125000.0              0.0                  0.0       79577.0   \n",
       "6     60          0.0           2500.0                  0.0       10356.0   \n",
       "7     60      25000.0           2500.0                  0.0       22546.0   \n",
       "8     60      50000.0           2500.0                  0.0       37837.0   \n",
       "9     60      75000.0           2500.0                  0.0       53215.0   \n",
       "10    60     100000.0           2500.0                  0.0       67724.0   \n",
       "11    60     125000.0           2500.0                  0.0       80890.0   \n",
       "12    60          0.0           5000.0                  0.0       10356.0   \n",
       "13    60      25000.0           5000.0                  0.0       24333.0   \n",
       "14    60      50000.0           5000.0                  0.0       39409.0   \n",
       "15    60      75000.0           5000.0                  0.0       54787.0   \n",
       "16    60     100000.0           5000.0                  0.0       69069.0   \n",
       "17    60     125000.0           5000.0                  0.0       82204.0   \n",
       "18    60          0.0           7500.0                  0.0       10356.0   \n",
       "19    60      25000.0           7500.0                  0.0       26120.0   \n",
       "20    60      50000.0           7500.0                  0.0       40981.0   \n",
       "21    60      75000.0           7500.0                  0.0       56359.0   \n",
       "22    60     100000.0           7500.0                  0.0       70382.0   \n",
       "23    60     125000.0           7500.0                  0.0       83517.0   \n",
       "24    60          0.0          10000.0                  0.0       10356.0   \n",
       "25    60      25000.0          10000.0                  0.0       27862.0   \n",
       "26    60      50000.0          10000.0                  0.0       42553.0   \n",
       "27    60      75000.0          10000.0                  0.0       57931.0   \n",
       "28    60     100000.0          10000.0                  0.0       71696.0   \n",
       "29    60     125000.0          10000.0                  0.0       84831.0   \n",
       "..   ...          ...              ...                  ...           ...   \n",
       "402   65          0.0           2500.0             125000.0       84559.0   \n",
       "403   65      25000.0           2500.0             125000.0       95682.0   \n",
       "404   65      50000.0           2500.0             125000.0      106265.0   \n",
       "405   65      75000.0           2500.0             125000.0      118348.0   \n",
       "406   65     100000.0           2500.0             125000.0      130022.0   \n",
       "407   65     125000.0           2500.0             125000.0      141696.0   \n",
       "408   65          0.0           5000.0             125000.0       85872.0   \n",
       "409   65      25000.0           5000.0             125000.0       96833.0   \n",
       "410   65      50000.0           5000.0             125000.0      107516.0   \n",
       "411   65      75000.0           5000.0             125000.0      119516.0   \n",
       "412   65     100000.0           5000.0             125000.0      131189.0   \n",
       "413   65     125000.0           5000.0             125000.0      142863.0   \n",
       "414   65          0.0           7500.0             125000.0       87186.0   \n",
       "415   65      25000.0           7500.0             125000.0       97984.0   \n",
       "416   65      50000.0           7500.0             125000.0      108767.0   \n",
       "417   65      75000.0           7500.0             125000.0      120683.0   \n",
       "418   65     100000.0           7500.0             125000.0      132357.0   \n",
       "419   65     125000.0           7500.0             125000.0      144031.0   \n",
       "420   65          0.0          10000.0             125000.0       88463.0   \n",
       "421   65      25000.0          10000.0             125000.0       99135.0   \n",
       "422   65      50000.0          10000.0             125000.0      110018.0   \n",
       "423   65      75000.0          10000.0             125000.0      121850.0   \n",
       "424   65     100000.0          10000.0             125000.0      133524.0   \n",
       "425   65     125000.0          10000.0             125000.0      145198.0   \n",
       "426   65          0.0          12500.0             125000.0       89677.0   \n",
       "427   65      25000.0          12500.0             125000.0      100376.0   \n",
       "428   65      50000.0          12500.0             125000.0      111268.0   \n",
       "429   65      75000.0          12500.0             125000.0      123018.0   \n",
       "430   65     100000.0          12500.0             125000.0      134692.0   \n",
       "431   65     125000.0          12500.0             125000.0      146365.0   \n",
       "\n",
       "     prov_inc_tax  fed_inc_tax  QC_NET_inc  QC_Taxable_Inc  OAS_inc  GIS_inc  \n",
       "0             0.0          0.0      7956.0             0.0      0.0      0.0  \n",
       "1          1238.0       1341.0     23870.0         23870.0      0.0      0.0  \n",
       "2          5768.0       4457.0     48870.0         48870.0      0.0      0.0  \n",
       "3         10768.0       8687.0     73870.0         73870.0      0.0      0.0  \n",
       "4         16332.0      13400.0     98870.0         98870.0      0.0      0.0  \n",
       "5         22695.0      18828.0    123870.0        123870.0      0.0      0.0  \n",
       "6             0.0          0.0     10356.0          2500.0      0.0      0.0  \n",
       "7          1638.0       1654.0     26370.0         26370.0      0.0      0.0  \n",
       "8          6268.0       4885.0     51370.0         51370.0      0.0      0.0  \n",
       "9         11268.0       9115.0     76370.0         76370.0      0.0      0.0  \n",
       "10        16932.0      13943.0    101370.0        101370.0      0.0      0.0  \n",
       "11        23338.0      19370.0    126370.0        126370.0      0.0      0.0  \n",
       "12            0.0          0.0     10356.0          5000.0      0.0      0.0  \n",
       "13         2038.0       1967.0     28870.0         28870.0      0.0      0.0  \n",
       "14         6768.0       5313.0     53870.0         53870.0      0.0      0.0  \n",
       "15        11768.0       9543.0     78870.0         78870.0      0.0      0.0  \n",
       "16        17545.0      14486.0    103870.0        103870.0      0.0      0.0  \n",
       "17        23982.0      19913.0    128870.0        128870.0      0.0      0.0  \n",
       "18            0.0          0.0     10356.0          7500.0      0.0      0.0  \n",
       "19         2438.0       2280.0     31370.0         31370.0      0.0      0.0  \n",
       "20         7268.0       5741.0     56370.0         56370.0      0.0      0.0  \n",
       "21        12268.0       9971.0     81370.0         81370.0      0.0      0.0  \n",
       "22        18188.0      15028.0    106370.0        106370.0      0.0      0.0  \n",
       "23        24626.0      20456.0    131370.0        131370.0      0.0      0.0  \n",
       "24            0.0          0.0     10356.0         10000.0      0.0      0.0  \n",
       "25         2883.0       2593.0     33870.0         33870.0      0.0      0.0  \n",
       "26         7768.0       6169.0     58870.0         58870.0      0.0      0.0  \n",
       "27        12768.0      10399.0     83870.0         83870.0      0.0      0.0  \n",
       "28        18832.0      15571.0    108870.0        108870.0      0.0      0.0  \n",
       "29        25270.0      20999.0    133870.0        133870.0      0.0      0.0  \n",
       "..            ...          ...         ...             ...      ...      ...  \n",
       "402       23187.0      19754.0    127500.0        127500.0   6879.0      0.0  \n",
       "403       30025.0      25131.0    151370.0        151370.0   6879.0      0.0  \n",
       "404       36771.0      30954.0    176370.0        176370.0   6879.0      0.0  \n",
       "405       43209.0      37042.0    201370.0        201370.0   6879.0      0.0  \n",
       "406       49646.0      43931.0    226370.0        226370.0   6879.0      0.0  \n",
       "407       56084.0      50819.0    251370.0        251370.0   6879.0      0.0  \n",
       "408       23831.0      20297.0    130000.0        130000.0   6879.0      0.0  \n",
       "409       30769.0      25737.0    153870.0        153870.0   6879.0      0.0  \n",
       "410       37415.0      31559.0    178870.0        178870.0   6879.0      0.0  \n",
       "411       43853.0      37731.0    203870.0        203870.0   6879.0      0.0  \n",
       "412       50290.0      44619.0    228870.0        228870.0   6879.0      0.0  \n",
       "413       56728.0      51508.0    253870.0        253870.0   6879.0      0.0  \n",
       "414       24475.0      20839.0    132500.0        132500.0   6879.0      0.0  \n",
       "415       31512.0      26342.0    156370.0        156370.0   6879.0      0.0  \n",
       "416       38059.0      32164.0    181370.0        181370.0   6879.0      0.0  \n",
       "417       44496.0      38420.0    206370.0        206370.0   6879.0      0.0  \n",
       "418       50934.0      45308.0    231370.0        231370.0   6879.0      0.0  \n",
       "419       57371.0      52197.0    256370.0        256370.0   6879.0      0.0  \n",
       "420       25155.0      21382.0    135000.0        135000.0   6879.0      0.0  \n",
       "421       32256.0      26947.0    158870.0        158870.0   6879.0      0.0  \n",
       "422       38703.0      32770.0    183870.0        183870.0   6879.0      0.0  \n",
       "423       45140.0      39108.0    208870.0        208870.0   6879.0      0.0  \n",
       "424       51578.0      45997.0    233870.0        233870.0   6879.0      0.0  \n",
       "425       58015.0      52886.0    258870.0        258870.0   6879.0      0.0  \n",
       "426       25899.0      21925.0    137500.0        137500.0   6879.0      0.0  \n",
       "427       32909.0      27553.0    161370.0        161370.0   6879.0      0.0  \n",
       "428       39346.0      33375.0    186370.0        186370.0   6879.0      0.0  \n",
       "429       45784.0      39797.0    211370.0        211370.0   6879.0      0.0  \n",
       "430       52221.0      46686.0    236370.0        236370.0   6879.0      0.0  \n",
       "431       58659.0      53575.0    261370.0        261370.0   6879.0      0.0  \n",
       "\n",
       "[432 rows x 11 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simtax_fortran_out"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Les variables disponibles dans la base Fortran"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['age', 'inc_earning', 'inc_CPP_pension', 'inc_private_pension',\n",
       "       'ind_disp_inc', 'prov_inc_tax', 'fed_inc_tax', 'QC_NET_inc',\n",
       "       'QC_Taxable_Inc', 'OAS_inc', 'GIS_inc'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_var_fortran =simtax_fortran_out.columns\n",
    "list_var_fortran"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Création de la base de données Python avec les même inputs que la base Fortran"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.0\n",
      "25000.0\n",
      "50000.0\n",
      "75000.0\n",
      "100000.0\n",
      "125000.0\n",
      "2500.0\n",
      "27500.0\n",
      "52500.0\n",
      "77500.0\n",
      "102500.0\n",
      "127500.0\n",
      "5000.0\n",
      "30000.0\n",
      "55000.0\n",
      "80000.0\n",
      "105000.0\n",
      "130000.0\n",
      "7500.0\n",
      "32500.0\n",
      "57500.0\n",
      "82500.0\n",
      "107500.0\n",
      "132500.0\n",
      "10000.0\n",
      "35000.0\n",
      "60000.0\n",
      "85000.0\n",
      "110000.0\n",
      "135000.0\n",
      "12500.0\n",
      "37500.0\n",
      "62500.0\n",
      "87500.0\n",
      "112500.0\n",
      "137500.0\n",
      "25000.0\n",
      "50000.0\n",
      "75000.0\n",
      "100000.0\n",
      "125000.0\n",
      "150000.0\n",
      "27500.0\n",
      "52500.0\n",
      "77500.0\n",
      "102500.0\n",
      "127500.0\n",
      "152500.0\n",
      "30000.0\n",
      "55000.0\n",
      "80000.0\n",
      "105000.0\n",
      "130000.0\n",
      "155000.0\n",
      "32500.0\n",
      "57500.0\n",
      "82500.0\n",
      "107500.0\n",
      "132500.0\n",
      "157500.0\n",
      "35000.0\n",
      "60000.0\n",
      "85000.0\n",
      "110000.0\n",
      "135000.0\n",
      "160000.0\n",
      "37500.0\n",
      "62500.0\n",
      "87500.0\n",
      "112500.0\n",
      "137500.0\n",
      "162500.0\n",
      "50000.0\n",
      "75000.0\n",
      "100000.0\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "52500.0\n",
      "77500.0\n",
      "102500.0\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "55000.0\n",
      "80000.0\n",
      "105000.0\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "57500.0\n",
      "82500.0\n",
      "107500.0\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "60000.0\n",
      "85000.0\n",
      "110000.0\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "62500.0\n",
      "87500.0\n",
      "112500.0\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "75000.0\n",
      "100000.0\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "77500.0\n",
      "102500.0\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "80000.0\n",
      "105000.0\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "82500.0\n",
      "107500.0\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "85000.0\n",
      "110000.0\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "87500.0\n",
      "112500.0\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "100000.0\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "225000.0\n",
      "102500.0\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "227500.0\n",
      "105000.0\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "230000.0\n",
      "107500.0\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "232500.0\n",
      "110000.0\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "235000.0\n",
      "112500.0\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "237500.0\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "225000.0\n",
      "250000.0\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "227500.0\n",
      "252500.0\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "230000.0\n",
      "255000.0\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "232500.0\n",
      "257500.0\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "235000.0\n",
      "260000.0\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "237500.0\n",
      "262500.0\n",
      "6878.819824000002\n",
      "31878.819824\n",
      "56878.819824000006\n",
      "81692.219824\n",
      "102942.219824\n",
      "125000.0\n",
      "9378.819824000002\n",
      "34378.819824\n",
      "59378.819824000006\n",
      "83817.219824\n",
      "105067.219824\n",
      "127500.0\n",
      "11878.819824000002\n",
      "36878.819824\n",
      "61878.819824000006\n",
      "85942.219824\n",
      "107192.219824\n",
      "130000.0\n",
      "14378.819824000002\n",
      "39378.819824000006\n",
      "64378.819824000006\n",
      "88067.219824\n",
      "109317.219824\n",
      "132500.0\n",
      "16878.819824000002\n",
      "41878.819824000006\n",
      "66878.819824\n",
      "90192.219824\n",
      "111442.219824\n",
      "135000.0\n",
      "19378.819824000002\n",
      "44378.819824000006\n",
      "69378.819824\n",
      "92317.219824\n",
      "113567.219824\n",
      "137500.0\n",
      "31878.819824000002\n",
      "56878.819824000006\n",
      "81692.219824\n",
      "102942.219824\n",
      "125000.0\n",
      "150000.0\n",
      "34378.819824000006\n",
      "59378.819824000006\n",
      "83817.219824\n",
      "105067.219824\n",
      "127500.0\n",
      "152500.0\n",
      "36878.819824000006\n",
      "61878.819824000006\n",
      "85942.219824\n",
      "107192.219824\n",
      "130000.0\n",
      "155000.0\n",
      "39378.819824000006\n",
      "64378.819824000006\n",
      "88067.219824\n",
      "109317.219824\n",
      "132500.0\n",
      "157500.0\n",
      "41878.819824000006\n",
      "66878.819824\n",
      "90192.219824\n",
      "111442.219824\n",
      "135000.0\n",
      "160000.0\n",
      "44378.819824000006\n",
      "69378.819824\n",
      "92317.219824\n",
      "113567.219824\n",
      "137500.0\n",
      "162500.0\n",
      "56878.819824000006\n",
      "81692.219824\n",
      "102942.219824\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "59378.819824000006\n",
      "83817.219824\n",
      "105067.219824\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "61878.819824000006\n",
      "85942.219824\n",
      "107192.219824\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "64378.819824000006\n",
      "88067.219824\n",
      "109317.219824\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "66878.819824\n",
      "90192.219824\n",
      "111442.219824\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "69378.819824\n",
      "92317.219824\n",
      "113567.219824\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "81692.219824\n",
      "102942.219824\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "83817.219824\n",
      "105067.219824\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "85942.219824\n",
      "107192.219824\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "88067.219824\n",
      "109317.219824\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "90192.219824\n",
      "111442.219824\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "92317.219824\n",
      "113567.219824\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "102942.219824\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "225000.0\n",
      "105067.219824\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "227500.0\n",
      "107192.219824\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "230000.0\n",
      "109317.219824\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "232500.0\n",
      "111442.219824\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "235000.0\n",
      "113567.219824\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "237500.0\n",
      "125000.0\n",
      "150000.0\n",
      "175000.0\n",
      "200000.0\n",
      "225000.0\n",
      "250000.0\n",
      "127500.0\n",
      "152500.0\n",
      "177500.0\n",
      "202500.0\n",
      "227500.0\n",
      "252500.0\n",
      "130000.0\n",
      "155000.0\n",
      "180000.0\n",
      "205000.0\n",
      "230000.0\n",
      "255000.0\n",
      "132500.0\n",
      "157500.0\n",
      "182500.0\n",
      "207500.0\n",
      "232500.0\n",
      "257500.0\n",
      "135000.0\n",
      "160000.0\n",
      "185000.0\n",
      "210000.0\n",
      "235000.0\n",
      "260000.0\n",
      "137500.0\n",
      "162500.0\n",
      "187500.0\n",
      "212500.0\n",
      "237500.0\n",
      "262500.0\n"
     ]
    }
   ],
   "source": [
    "simtax_py_out=pd.DataFrame()\n",
    "for i in range(0,len(simtax_fortran_out.index)):\n",
    "    ind = person(age=simtax_fortran_out.loc[i, 'age'], \n",
    "                 earn = simtax_fortran_out.loc[i, 'inc_earning'], \n",
    "                 cpp=simtax_fortran_out.loc[i,'inc_CPP_pension'],\n",
    "                 rpp=simtax_fortran_out.loc[i,'inc_private_pension'])\n",
    "    hh= hhold(ind)\n",
    "    hh_tax=tax()\n",
    "    hh_tax.file(hh)\n",
    "    simtax_py_out.loc[i,'pinc']= hh_tax.pinc(hh,0)\n",
    "    simtax_py_out.loc[i,'paftertax']=hh_tax.paftertax(hh,0)\n",
    "    simtax_py_out.loc[i, 'pro_liab'] = hh_tax.proforms[0].liab\n",
    "    simtax_py_out.loc[i, 'fed_liab'] = hh_tax.fedforms[0].liab\n",
    "    simtax_py_out.loc[i, 'totinc'] = hh_tax.fedforms[0].totinc "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pinc</th>\n",
       "      <th>paftertax</th>\n",
       "      <th>pro_liab</th>\n",
       "      <th>fed_liab</th>\n",
       "      <th>totinc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1073.52002</td>\n",
       "      <td>1073.520020</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20323.52002</td>\n",
       "      <td>18578.370020</td>\n",
       "      <td>335.000</td>\n",
       "      <td>1410.150000</td>\n",
       "      <td>20323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>39073.52002</td>\n",
       "      <td>28321.045870</td>\n",
       "      <td>5994.400</td>\n",
       "      <td>4758.074150</td>\n",
       "      <td>39073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>57823.52002</td>\n",
       "      <td>37791.670870</td>\n",
       "      <td>10994.400</td>\n",
       "      <td>9037.449150</td>\n",
       "      <td>57823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>76573.52002</td>\n",
       "      <td>46220.101645</td>\n",
       "      <td>16603.200</td>\n",
       "      <td>13750.218375</td>\n",
       "      <td>76573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>95323.52002</td>\n",
       "      <td>53160.226645</td>\n",
       "      <td>22985.575</td>\n",
       "      <td>19177.718375</td>\n",
       "      <td>95323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3448.52002</td>\n",
       "      <td>3448.520020</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>22198.52002</td>\n",
       "      <td>19740.245020</td>\n",
       "      <td>735.000</td>\n",
       "      <td>1723.275000</td>\n",
       "      <td>22198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>40948.52002</td>\n",
       "      <td>29268.108370</td>\n",
       "      <td>6494.400</td>\n",
       "      <td>5186.011650</td>\n",
       "      <td>40948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>59698.52002</td>\n",
       "      <td>38738.733370</td>\n",
       "      <td>11494.400</td>\n",
       "      <td>9465.386650</td>\n",
       "      <td>59698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>78448.52002</td>\n",
       "      <td>46952.351645</td>\n",
       "      <td>17203.200</td>\n",
       "      <td>14292.968375</td>\n",
       "      <td>78448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>97198.52002</td>\n",
       "      <td>53848.726645</td>\n",
       "      <td>23629.325</td>\n",
       "      <td>19720.468375</td>\n",
       "      <td>97198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>5323.52002</td>\n",
       "      <td>5323.520020</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>24073.52002</td>\n",
       "      <td>20902.120020</td>\n",
       "      <td>1135.000</td>\n",
       "      <td>2036.400000</td>\n",
       "      <td>24073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>42823.52002</td>\n",
       "      <td>30215.170870</td>\n",
       "      <td>6994.400</td>\n",
       "      <td>5613.949150</td>\n",
       "      <td>42823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>61573.52002</td>\n",
       "      <td>39685.795870</td>\n",
       "      <td>11994.400</td>\n",
       "      <td>9893.324150</td>\n",
       "      <td>61573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>80323.52002</td>\n",
       "      <td>47652.226645</td>\n",
       "      <td>17835.575</td>\n",
       "      <td>14835.718375</td>\n",
       "      <td>80323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>99073.52002</td>\n",
       "      <td>54537.226645</td>\n",
       "      <td>24273.075</td>\n",
       "      <td>20263.218375</td>\n",
       "      <td>99073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>7198.52002</td>\n",
       "      <td>7198.520020</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>25948.52002</td>\n",
       "      <td>22063.995020</td>\n",
       "      <td>1535.000</td>\n",
       "      <td>2349.525000</td>\n",
       "      <td>25948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>44698.52002</td>\n",
       "      <td>31162.233370</td>\n",
       "      <td>7494.400</td>\n",
       "      <td>6041.886650</td>\n",
       "      <td>44698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>63448.52002</td>\n",
       "      <td>40632.858370</td>\n",
       "      <td>12494.400</td>\n",
       "      <td>10321.261650</td>\n",
       "      <td>63448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>82198.52002</td>\n",
       "      <td>48340.726645</td>\n",
       "      <td>18479.325</td>\n",
       "      <td>15378.468375</td>\n",
       "      <td>82198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>100948.52002</td>\n",
       "      <td>55225.726645</td>\n",
       "      <td>24916.825</td>\n",
       "      <td>20805.968375</td>\n",
       "      <td>100948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>9073.52002</td>\n",
       "      <td>9073.520020</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>27823.52002</td>\n",
       "      <td>22926.870020</td>\n",
       "      <td>2234.000</td>\n",
       "      <td>2662.650000</td>\n",
       "      <td>27823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>46573.52002</td>\n",
       "      <td>32109.295870</td>\n",
       "      <td>7994.400</td>\n",
       "      <td>6469.824150</td>\n",
       "      <td>46573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>65323.52002</td>\n",
       "      <td>41571.120870</td>\n",
       "      <td>13003.200</td>\n",
       "      <td>10749.199150</td>\n",
       "      <td>65323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>84073.52002</td>\n",
       "      <td>49029.226645</td>\n",
       "      <td>19123.075</td>\n",
       "      <td>15921.218375</td>\n",
       "      <td>84073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>102823.52002</td>\n",
       "      <td>55914.226645</td>\n",
       "      <td>25560.575</td>\n",
       "      <td>21348.718375</td>\n",
       "      <td>102823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>97198.52002</td>\n",
       "      <td>54590.726645</td>\n",
       "      <td>23187.325</td>\n",
       "      <td>19420.468375</td>\n",
       "      <td>97198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>115948.52002</td>\n",
       "      <td>61172.321045</td>\n",
       "      <td>29624.825</td>\n",
       "      <td>25151.373975</td>\n",
       "      <td>115948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>134698.52002</td>\n",
       "      <td>67431.071045</td>\n",
       "      <td>36062.325</td>\n",
       "      <td>31205.123975</td>\n",
       "      <td>134698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>153448.52002</td>\n",
       "      <td>73606.321045</td>\n",
       "      <td>42499.825</td>\n",
       "      <td>37342.373975</td>\n",
       "      <td>153448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>172198.52002</td>\n",
       "      <td>79030.071045</td>\n",
       "      <td>48937.325</td>\n",
       "      <td>44231.123975</td>\n",
       "      <td>172198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>190948.52002</td>\n",
       "      <td>84453.821045</td>\n",
       "      <td>55374.825</td>\n",
       "      <td>51119.873975</td>\n",
       "      <td>190948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>99073.52002</td>\n",
       "      <td>55279.226645</td>\n",
       "      <td>23831.075</td>\n",
       "      <td>19963.218375</td>\n",
       "      <td>99073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>117823.52002</td>\n",
       "      <td>61798.196045</td>\n",
       "      <td>30268.575</td>\n",
       "      <td>25756.748975</td>\n",
       "      <td>117823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>136573.52002</td>\n",
       "      <td>68056.946045</td>\n",
       "      <td>36706.075</td>\n",
       "      <td>31810.498975</td>\n",
       "      <td>136573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>155323.52002</td>\n",
       "      <td>74148.696045</td>\n",
       "      <td>43143.575</td>\n",
       "      <td>38031.248975</td>\n",
       "      <td>155323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>174073.52002</td>\n",
       "      <td>79572.446045</td>\n",
       "      <td>49581.075</td>\n",
       "      <td>44919.998975</td>\n",
       "      <td>174073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>192823.52002</td>\n",
       "      <td>84996.196045</td>\n",
       "      <td>56018.575</td>\n",
       "      <td>51808.748975</td>\n",
       "      <td>192823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>100948.52002</td>\n",
       "      <td>55967.726645</td>\n",
       "      <td>24474.825</td>\n",
       "      <td>20505.968375</td>\n",
       "      <td>100948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>119698.52002</td>\n",
       "      <td>62424.071045</td>\n",
       "      <td>30912.325</td>\n",
       "      <td>26362.123975</td>\n",
       "      <td>119698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>138448.52002</td>\n",
       "      <td>68682.821045</td>\n",
       "      <td>37349.825</td>\n",
       "      <td>32415.873975</td>\n",
       "      <td>138448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>157198.52002</td>\n",
       "      <td>74691.071045</td>\n",
       "      <td>43787.325</td>\n",
       "      <td>38720.123975</td>\n",
       "      <td>157198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>175948.52002</td>\n",
       "      <td>80114.821045</td>\n",
       "      <td>50224.825</td>\n",
       "      <td>45608.873975</td>\n",
       "      <td>175948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>194698.52002</td>\n",
       "      <td>85538.571045</td>\n",
       "      <td>56662.325</td>\n",
       "      <td>52497.623975</td>\n",
       "      <td>194698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>102823.52002</td>\n",
       "      <td>56656.226645</td>\n",
       "      <td>25118.575</td>\n",
       "      <td>21048.718375</td>\n",
       "      <td>102823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>121573.52002</td>\n",
       "      <td>63049.946045</td>\n",
       "      <td>31556.075</td>\n",
       "      <td>26967.498975</td>\n",
       "      <td>121573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>140323.52002</td>\n",
       "      <td>69308.696045</td>\n",
       "      <td>37993.575</td>\n",
       "      <td>33021.248975</td>\n",
       "      <td>140323.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>159073.52002</td>\n",
       "      <td>75233.446045</td>\n",
       "      <td>44431.075</td>\n",
       "      <td>39408.998975</td>\n",
       "      <td>159073.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>177823.52002</td>\n",
       "      <td>80657.196045</td>\n",
       "      <td>50868.575</td>\n",
       "      <td>46297.748975</td>\n",
       "      <td>177823.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>196573.52002</td>\n",
       "      <td>86080.946045</td>\n",
       "      <td>57306.075</td>\n",
       "      <td>53186.498975</td>\n",
       "      <td>196573.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>104698.52002</td>\n",
       "      <td>57344.726645</td>\n",
       "      <td>25762.325</td>\n",
       "      <td>21591.468375</td>\n",
       "      <td>104698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>123448.52002</td>\n",
       "      <td>63675.821045</td>\n",
       "      <td>32199.825</td>\n",
       "      <td>27572.873975</td>\n",
       "      <td>123448.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>142198.52002</td>\n",
       "      <td>69934.571045</td>\n",
       "      <td>38637.325</td>\n",
       "      <td>33626.623975</td>\n",
       "      <td>142198.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>160948.52002</td>\n",
       "      <td>75775.821045</td>\n",
       "      <td>45074.825</td>\n",
       "      <td>40097.873975</td>\n",
       "      <td>160948.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>179698.52002</td>\n",
       "      <td>81199.571045</td>\n",
       "      <td>51512.325</td>\n",
       "      <td>46986.623975</td>\n",
       "      <td>179698.52002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>198448.52002</td>\n",
       "      <td>86623.321045</td>\n",
       "      <td>57949.825</td>\n",
       "      <td>53875.373975</td>\n",
       "      <td>198448.52002</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>432 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             pinc     paftertax   pro_liab      fed_liab        totinc\n",
       "0      1073.52002   1073.520020      0.000      0.000000    1073.52002\n",
       "1     20323.52002  18578.370020    335.000   1410.150000   20323.52002\n",
       "2     39073.52002  28321.045870   5994.400   4758.074150   39073.52002\n",
       "3     57823.52002  37791.670870  10994.400   9037.449150   57823.52002\n",
       "4     76573.52002  46220.101645  16603.200  13750.218375   76573.52002\n",
       "5     95323.52002  53160.226645  22985.575  19177.718375   95323.52002\n",
       "6      3448.52002   3448.520020      0.000      0.000000    3448.52002\n",
       "7     22198.52002  19740.245020    735.000   1723.275000   22198.52002\n",
       "8     40948.52002  29268.108370   6494.400   5186.011650   40948.52002\n",
       "9     59698.52002  38738.733370  11494.400   9465.386650   59698.52002\n",
       "10    78448.52002  46952.351645  17203.200  14292.968375   78448.52002\n",
       "11    97198.52002  53848.726645  23629.325  19720.468375   97198.52002\n",
       "12     5323.52002   5323.520020      0.000      0.000000    5323.52002\n",
       "13    24073.52002  20902.120020   1135.000   2036.400000   24073.52002\n",
       "14    42823.52002  30215.170870   6994.400   5613.949150   42823.52002\n",
       "15    61573.52002  39685.795870  11994.400   9893.324150   61573.52002\n",
       "16    80323.52002  47652.226645  17835.575  14835.718375   80323.52002\n",
       "17    99073.52002  54537.226645  24273.075  20263.218375   99073.52002\n",
       "18     7198.52002   7198.520020      0.000      0.000000    7198.52002\n",
       "19    25948.52002  22063.995020   1535.000   2349.525000   25948.52002\n",
       "20    44698.52002  31162.233370   7494.400   6041.886650   44698.52002\n",
       "21    63448.52002  40632.858370  12494.400  10321.261650   63448.52002\n",
       "22    82198.52002  48340.726645  18479.325  15378.468375   82198.52002\n",
       "23   100948.52002  55225.726645  24916.825  20805.968375  100948.52002\n",
       "24     9073.52002   9073.520020      0.000      0.000000    9073.52002\n",
       "25    27823.52002  22926.870020   2234.000   2662.650000   27823.52002\n",
       "26    46573.52002  32109.295870   7994.400   6469.824150   46573.52002\n",
       "27    65323.52002  41571.120870  13003.200  10749.199150   65323.52002\n",
       "28    84073.52002  49029.226645  19123.075  15921.218375   84073.52002\n",
       "29   102823.52002  55914.226645  25560.575  21348.718375  102823.52002\n",
       "..            ...           ...        ...           ...           ...\n",
       "402   97198.52002  54590.726645  23187.325  19420.468375   97198.52002\n",
       "403  115948.52002  61172.321045  29624.825  25151.373975  115948.52002\n",
       "404  134698.52002  67431.071045  36062.325  31205.123975  134698.52002\n",
       "405  153448.52002  73606.321045  42499.825  37342.373975  153448.52002\n",
       "406  172198.52002  79030.071045  48937.325  44231.123975  172198.52002\n",
       "407  190948.52002  84453.821045  55374.825  51119.873975  190948.52002\n",
       "408   99073.52002  55279.226645  23831.075  19963.218375   99073.52002\n",
       "409  117823.52002  61798.196045  30268.575  25756.748975  117823.52002\n",
       "410  136573.52002  68056.946045  36706.075  31810.498975  136573.52002\n",
       "411  155323.52002  74148.696045  43143.575  38031.248975  155323.52002\n",
       "412  174073.52002  79572.446045  49581.075  44919.998975  174073.52002\n",
       "413  192823.52002  84996.196045  56018.575  51808.748975  192823.52002\n",
       "414  100948.52002  55967.726645  24474.825  20505.968375  100948.52002\n",
       "415  119698.52002  62424.071045  30912.325  26362.123975  119698.52002\n",
       "416  138448.52002  68682.821045  37349.825  32415.873975  138448.52002\n",
       "417  157198.52002  74691.071045  43787.325  38720.123975  157198.52002\n",
       "418  175948.52002  80114.821045  50224.825  45608.873975  175948.52002\n",
       "419  194698.52002  85538.571045  56662.325  52497.623975  194698.52002\n",
       "420  102823.52002  56656.226645  25118.575  21048.718375  102823.52002\n",
       "421  121573.52002  63049.946045  31556.075  26967.498975  121573.52002\n",
       "422  140323.52002  69308.696045  37993.575  33021.248975  140323.52002\n",
       "423  159073.52002  75233.446045  44431.075  39408.998975  159073.52002\n",
       "424  177823.52002  80657.196045  50868.575  46297.748975  177823.52002\n",
       "425  196573.52002  86080.946045  57306.075  53186.498975  196573.52002\n",
       "426  104698.52002  57344.726645  25762.325  21591.468375  104698.52002\n",
       "427  123448.52002  63675.821045  32199.825  27572.873975  123448.52002\n",
       "428  142198.52002  69934.571045  38637.325  33626.623975  142198.52002\n",
       "429  160948.52002  75775.821045  45074.825  40097.873975  160948.52002\n",
       "430  179698.52002  81199.571045  51512.325  46986.623975  179698.52002\n",
       "431  198448.52002  86623.321045  57949.825  53875.373975  198448.52002\n",
       "\n",
       "[432 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "simtax_py_out"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Variables de la base de données simtax_py_out"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['pinc', 'paftertax', 'pro_liab', 'fed_liab', 'totinc'], dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list_var_py=simtax_py_out.columns\n",
    "list_var_py"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Concatenation des deux bases de données"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "comparaison = pd.concat([simtax_fortran_out,simtax_py_out], axis=1)\n",
    "comparaison = round(comparaison)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>inc_earning</th>\n",
       "      <th>inc_CPP_pension</th>\n",
       "      <th>inc_private_pension</th>\n",
       "      <th>ind_disp_inc</th>\n",
       "      <th>prov_inc_tax</th>\n",
       "      <th>fed_inc_tax</th>\n",
       "      <th>QC_NET_inc</th>\n",
       "      <th>QC_Taxable_Inc</th>\n",
       "      <th>OAS_inc</th>\n",
       "      <th>GIS_inc</th>\n",
       "      <th>pinc</th>\n",
       "      <th>paftertax</th>\n",
       "      <th>pro_liab</th>\n",
       "      <th>fed_liab</th>\n",
       "      <th>totinc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20759.0</td>\n",
       "      <td>1238.0</td>\n",
       "      <td>1341.0</td>\n",
       "      <td>23870.0</td>\n",
       "      <td>23870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20324.0</td>\n",
       "      <td>18578.0</td>\n",
       "      <td>335.0</td>\n",
       "      <td>1410.0</td>\n",
       "      <td>20324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36264.0</td>\n",
       "      <td>5768.0</td>\n",
       "      <td>4457.0</td>\n",
       "      <td>48870.0</td>\n",
       "      <td>48870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39074.0</td>\n",
       "      <td>28321.0</td>\n",
       "      <td>5994.0</td>\n",
       "      <td>4758.0</td>\n",
       "      <td>39074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51643.0</td>\n",
       "      <td>10768.0</td>\n",
       "      <td>8687.0</td>\n",
       "      <td>73870.0</td>\n",
       "      <td>73870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57824.0</td>\n",
       "      <td>37792.0</td>\n",
       "      <td>10994.0</td>\n",
       "      <td>9037.0</td>\n",
       "      <td>57824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66367.0</td>\n",
       "      <td>16332.0</td>\n",
       "      <td>13400.0</td>\n",
       "      <td>98870.0</td>\n",
       "      <td>98870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>76574.0</td>\n",
       "      <td>46220.0</td>\n",
       "      <td>16603.0</td>\n",
       "      <td>13750.0</td>\n",
       "      <td>76574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79577.0</td>\n",
       "      <td>22695.0</td>\n",
       "      <td>18828.0</td>\n",
       "      <td>123870.0</td>\n",
       "      <td>123870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95324.0</td>\n",
       "      <td>53160.0</td>\n",
       "      <td>22986.0</td>\n",
       "      <td>19178.0</td>\n",
       "      <td>95324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3449.0</td>\n",
       "      <td>3449.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22546.0</td>\n",
       "      <td>1638.0</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>26370.0</td>\n",
       "      <td>26370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22199.0</td>\n",
       "      <td>19740.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>1723.0</td>\n",
       "      <td>22199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37837.0</td>\n",
       "      <td>6268.0</td>\n",
       "      <td>4885.0</td>\n",
       "      <td>51370.0</td>\n",
       "      <td>51370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40949.0</td>\n",
       "      <td>29268.0</td>\n",
       "      <td>6494.0</td>\n",
       "      <td>5186.0</td>\n",
       "      <td>40949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53215.0</td>\n",
       "      <td>11268.0</td>\n",
       "      <td>9115.0</td>\n",
       "      <td>76370.0</td>\n",
       "      <td>76370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>59699.0</td>\n",
       "      <td>38739.0</td>\n",
       "      <td>11494.0</td>\n",
       "      <td>9465.0</td>\n",
       "      <td>59699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67724.0</td>\n",
       "      <td>16932.0</td>\n",
       "      <td>13943.0</td>\n",
       "      <td>101370.0</td>\n",
       "      <td>101370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>78449.0</td>\n",
       "      <td>46952.0</td>\n",
       "      <td>17203.0</td>\n",
       "      <td>14293.0</td>\n",
       "      <td>78449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80890.0</td>\n",
       "      <td>23338.0</td>\n",
       "      <td>19370.0</td>\n",
       "      <td>126370.0</td>\n",
       "      <td>126370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97199.0</td>\n",
       "      <td>53849.0</td>\n",
       "      <td>23629.0</td>\n",
       "      <td>19720.0</td>\n",
       "      <td>97199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5324.0</td>\n",
       "      <td>5324.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24333.0</td>\n",
       "      <td>2038.0</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>28870.0</td>\n",
       "      <td>28870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24074.0</td>\n",
       "      <td>20902.0</td>\n",
       "      <td>1135.0</td>\n",
       "      <td>2036.0</td>\n",
       "      <td>24074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39409.0</td>\n",
       "      <td>6768.0</td>\n",
       "      <td>5313.0</td>\n",
       "      <td>53870.0</td>\n",
       "      <td>53870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42824.0</td>\n",
       "      <td>30215.0</td>\n",
       "      <td>6994.0</td>\n",
       "      <td>5614.0</td>\n",
       "      <td>42824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54787.0</td>\n",
       "      <td>11768.0</td>\n",
       "      <td>9543.0</td>\n",
       "      <td>78870.0</td>\n",
       "      <td>78870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>61574.0</td>\n",
       "      <td>39686.0</td>\n",
       "      <td>11994.0</td>\n",
       "      <td>9893.0</td>\n",
       "      <td>61574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69069.0</td>\n",
       "      <td>17545.0</td>\n",
       "      <td>14486.0</td>\n",
       "      <td>103870.0</td>\n",
       "      <td>103870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80324.0</td>\n",
       "      <td>47652.0</td>\n",
       "      <td>17836.0</td>\n",
       "      <td>14836.0</td>\n",
       "      <td>80324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82204.0</td>\n",
       "      <td>23982.0</td>\n",
       "      <td>19913.0</td>\n",
       "      <td>128870.0</td>\n",
       "      <td>128870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99074.0</td>\n",
       "      <td>54537.0</td>\n",
       "      <td>24273.0</td>\n",
       "      <td>20263.0</td>\n",
       "      <td>99074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26120.0</td>\n",
       "      <td>2438.0</td>\n",
       "      <td>2280.0</td>\n",
       "      <td>31370.0</td>\n",
       "      <td>31370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25949.0</td>\n",
       "      <td>22064.0</td>\n",
       "      <td>1535.0</td>\n",
       "      <td>2350.0</td>\n",
       "      <td>25949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40981.0</td>\n",
       "      <td>7268.0</td>\n",
       "      <td>5741.0</td>\n",
       "      <td>56370.0</td>\n",
       "      <td>56370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>44699.0</td>\n",
       "      <td>31162.0</td>\n",
       "      <td>7494.0</td>\n",
       "      <td>6042.0</td>\n",
       "      <td>44699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56359.0</td>\n",
       "      <td>12268.0</td>\n",
       "      <td>9971.0</td>\n",
       "      <td>81370.0</td>\n",
       "      <td>81370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>63449.0</td>\n",
       "      <td>40633.0</td>\n",
       "      <td>12494.0</td>\n",
       "      <td>10321.0</td>\n",
       "      <td>63449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70382.0</td>\n",
       "      <td>18188.0</td>\n",
       "      <td>15028.0</td>\n",
       "      <td>106370.0</td>\n",
       "      <td>106370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82199.0</td>\n",
       "      <td>48341.0</td>\n",
       "      <td>18479.0</td>\n",
       "      <td>15378.0</td>\n",
       "      <td>82199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83517.0</td>\n",
       "      <td>24626.0</td>\n",
       "      <td>20456.0</td>\n",
       "      <td>131370.0</td>\n",
       "      <td>131370.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100949.0</td>\n",
       "      <td>55226.0</td>\n",
       "      <td>24917.0</td>\n",
       "      <td>20806.0</td>\n",
       "      <td>100949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9074.0</td>\n",
       "      <td>9074.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27862.0</td>\n",
       "      <td>2883.0</td>\n",
       "      <td>2593.0</td>\n",
       "      <td>33870.0</td>\n",
       "      <td>33870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27824.0</td>\n",
       "      <td>22927.0</td>\n",
       "      <td>2234.0</td>\n",
       "      <td>2663.0</td>\n",
       "      <td>27824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42553.0</td>\n",
       "      <td>7768.0</td>\n",
       "      <td>6169.0</td>\n",
       "      <td>58870.0</td>\n",
       "      <td>58870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46574.0</td>\n",
       "      <td>32109.0</td>\n",
       "      <td>7994.0</td>\n",
       "      <td>6470.0</td>\n",
       "      <td>46574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57931.0</td>\n",
       "      <td>12768.0</td>\n",
       "      <td>10399.0</td>\n",
       "      <td>83870.0</td>\n",
       "      <td>83870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>65324.0</td>\n",
       "      <td>41571.0</td>\n",
       "      <td>13003.0</td>\n",
       "      <td>10749.0</td>\n",
       "      <td>65324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71696.0</td>\n",
       "      <td>18832.0</td>\n",
       "      <td>15571.0</td>\n",
       "      <td>108870.0</td>\n",
       "      <td>108870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84074.0</td>\n",
       "      <td>49029.0</td>\n",
       "      <td>19123.0</td>\n",
       "      <td>15921.0</td>\n",
       "      <td>84074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84831.0</td>\n",
       "      <td>25270.0</td>\n",
       "      <td>20999.0</td>\n",
       "      <td>133870.0</td>\n",
       "      <td>133870.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>102824.0</td>\n",
       "      <td>55914.0</td>\n",
       "      <td>25561.0</td>\n",
       "      <td>21349.0</td>\n",
       "      <td>102824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>84559.0</td>\n",
       "      <td>23187.0</td>\n",
       "      <td>19754.0</td>\n",
       "      <td>127500.0</td>\n",
       "      <td>127500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97199.0</td>\n",
       "      <td>54591.0</td>\n",
       "      <td>23187.0</td>\n",
       "      <td>19420.0</td>\n",
       "      <td>97199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>95682.0</td>\n",
       "      <td>30025.0</td>\n",
       "      <td>25131.0</td>\n",
       "      <td>151370.0</td>\n",
       "      <td>151370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>115949.0</td>\n",
       "      <td>61172.0</td>\n",
       "      <td>29625.0</td>\n",
       "      <td>25151.0</td>\n",
       "      <td>115949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>106265.0</td>\n",
       "      <td>36771.0</td>\n",
       "      <td>30954.0</td>\n",
       "      <td>176370.0</td>\n",
       "      <td>176370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134699.0</td>\n",
       "      <td>67431.0</td>\n",
       "      <td>36062.0</td>\n",
       "      <td>31205.0</td>\n",
       "      <td>134699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>118348.0</td>\n",
       "      <td>43209.0</td>\n",
       "      <td>37042.0</td>\n",
       "      <td>201370.0</td>\n",
       "      <td>201370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>153449.0</td>\n",
       "      <td>73606.0</td>\n",
       "      <td>42500.0</td>\n",
       "      <td>37342.0</td>\n",
       "      <td>153449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>130022.0</td>\n",
       "      <td>49646.0</td>\n",
       "      <td>43931.0</td>\n",
       "      <td>226370.0</td>\n",
       "      <td>226370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>172199.0</td>\n",
       "      <td>79030.0</td>\n",
       "      <td>48937.0</td>\n",
       "      <td>44231.0</td>\n",
       "      <td>172199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>141696.0</td>\n",
       "      <td>56084.0</td>\n",
       "      <td>50819.0</td>\n",
       "      <td>251370.0</td>\n",
       "      <td>251370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>190949.0</td>\n",
       "      <td>84454.0</td>\n",
       "      <td>55375.0</td>\n",
       "      <td>51120.0</td>\n",
       "      <td>190949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>85872.0</td>\n",
       "      <td>23831.0</td>\n",
       "      <td>20297.0</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99074.0</td>\n",
       "      <td>55279.0</td>\n",
       "      <td>23831.0</td>\n",
       "      <td>19963.0</td>\n",
       "      <td>99074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>96833.0</td>\n",
       "      <td>30769.0</td>\n",
       "      <td>25737.0</td>\n",
       "      <td>153870.0</td>\n",
       "      <td>153870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>117824.0</td>\n",
       "      <td>61798.0</td>\n",
       "      <td>30269.0</td>\n",
       "      <td>25757.0</td>\n",
       "      <td>117824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>107516.0</td>\n",
       "      <td>37415.0</td>\n",
       "      <td>31559.0</td>\n",
       "      <td>178870.0</td>\n",
       "      <td>178870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>136574.0</td>\n",
       "      <td>68057.0</td>\n",
       "      <td>36706.0</td>\n",
       "      <td>31810.0</td>\n",
       "      <td>136574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>119516.0</td>\n",
       "      <td>43853.0</td>\n",
       "      <td>37731.0</td>\n",
       "      <td>203870.0</td>\n",
       "      <td>203870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155324.0</td>\n",
       "      <td>74149.0</td>\n",
       "      <td>43144.0</td>\n",
       "      <td>38031.0</td>\n",
       "      <td>155324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>131189.0</td>\n",
       "      <td>50290.0</td>\n",
       "      <td>44619.0</td>\n",
       "      <td>228870.0</td>\n",
       "      <td>228870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>174074.0</td>\n",
       "      <td>79572.0</td>\n",
       "      <td>49581.0</td>\n",
       "      <td>44920.0</td>\n",
       "      <td>174074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>142863.0</td>\n",
       "      <td>56728.0</td>\n",
       "      <td>51508.0</td>\n",
       "      <td>253870.0</td>\n",
       "      <td>253870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>192824.0</td>\n",
       "      <td>84996.0</td>\n",
       "      <td>56019.0</td>\n",
       "      <td>51809.0</td>\n",
       "      <td>192824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>87186.0</td>\n",
       "      <td>24475.0</td>\n",
       "      <td>20839.0</td>\n",
       "      <td>132500.0</td>\n",
       "      <td>132500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100949.0</td>\n",
       "      <td>55968.0</td>\n",
       "      <td>24475.0</td>\n",
       "      <td>20506.0</td>\n",
       "      <td>100949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>97984.0</td>\n",
       "      <td>31512.0</td>\n",
       "      <td>26342.0</td>\n",
       "      <td>156370.0</td>\n",
       "      <td>156370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>119699.0</td>\n",
       "      <td>62424.0</td>\n",
       "      <td>30912.0</td>\n",
       "      <td>26362.0</td>\n",
       "      <td>119699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>108767.0</td>\n",
       "      <td>38059.0</td>\n",
       "      <td>32164.0</td>\n",
       "      <td>181370.0</td>\n",
       "      <td>181370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>138449.0</td>\n",
       "      <td>68683.0</td>\n",
       "      <td>37350.0</td>\n",
       "      <td>32416.0</td>\n",
       "      <td>138449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>120683.0</td>\n",
       "      <td>44496.0</td>\n",
       "      <td>38420.0</td>\n",
       "      <td>206370.0</td>\n",
       "      <td>206370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>157199.0</td>\n",
       "      <td>74691.0</td>\n",
       "      <td>43787.0</td>\n",
       "      <td>38720.0</td>\n",
       "      <td>157199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>132357.0</td>\n",
       "      <td>50934.0</td>\n",
       "      <td>45308.0</td>\n",
       "      <td>231370.0</td>\n",
       "      <td>231370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>175949.0</td>\n",
       "      <td>80115.0</td>\n",
       "      <td>50225.0</td>\n",
       "      <td>45609.0</td>\n",
       "      <td>175949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>144031.0</td>\n",
       "      <td>57371.0</td>\n",
       "      <td>52197.0</td>\n",
       "      <td>256370.0</td>\n",
       "      <td>256370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>194699.0</td>\n",
       "      <td>85539.0</td>\n",
       "      <td>56662.0</td>\n",
       "      <td>52498.0</td>\n",
       "      <td>194699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>88463.0</td>\n",
       "      <td>25155.0</td>\n",
       "      <td>21382.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>102824.0</td>\n",
       "      <td>56656.0</td>\n",
       "      <td>25119.0</td>\n",
       "      <td>21049.0</td>\n",
       "      <td>102824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>99135.0</td>\n",
       "      <td>32256.0</td>\n",
       "      <td>26947.0</td>\n",
       "      <td>158870.0</td>\n",
       "      <td>158870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>121574.0</td>\n",
       "      <td>63050.0</td>\n",
       "      <td>31556.0</td>\n",
       "      <td>26967.0</td>\n",
       "      <td>121574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>110018.0</td>\n",
       "      <td>38703.0</td>\n",
       "      <td>32770.0</td>\n",
       "      <td>183870.0</td>\n",
       "      <td>183870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>140324.0</td>\n",
       "      <td>69309.0</td>\n",
       "      <td>37994.0</td>\n",
       "      <td>33021.0</td>\n",
       "      <td>140324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>121850.0</td>\n",
       "      <td>45140.0</td>\n",
       "      <td>39108.0</td>\n",
       "      <td>208870.0</td>\n",
       "      <td>208870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>159074.0</td>\n",
       "      <td>75233.0</td>\n",
       "      <td>44431.0</td>\n",
       "      <td>39409.0</td>\n",
       "      <td>159074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>133524.0</td>\n",
       "      <td>51578.0</td>\n",
       "      <td>45997.0</td>\n",
       "      <td>233870.0</td>\n",
       "      <td>233870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>177824.0</td>\n",
       "      <td>80657.0</td>\n",
       "      <td>50869.0</td>\n",
       "      <td>46298.0</td>\n",
       "      <td>177824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>145198.0</td>\n",
       "      <td>58015.0</td>\n",
       "      <td>52886.0</td>\n",
       "      <td>258870.0</td>\n",
       "      <td>258870.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>196574.0</td>\n",
       "      <td>86081.0</td>\n",
       "      <td>57306.0</td>\n",
       "      <td>53186.0</td>\n",
       "      <td>196574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>89677.0</td>\n",
       "      <td>25899.0</td>\n",
       "      <td>21925.0</td>\n",
       "      <td>137500.0</td>\n",
       "      <td>137500.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>104699.0</td>\n",
       "      <td>57345.0</td>\n",
       "      <td>25762.0</td>\n",
       "      <td>21591.0</td>\n",
       "      <td>104699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>100376.0</td>\n",
       "      <td>32909.0</td>\n",
       "      <td>27553.0</td>\n",
       "      <td>161370.0</td>\n",
       "      <td>161370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>123449.0</td>\n",
       "      <td>63676.0</td>\n",
       "      <td>32200.0</td>\n",
       "      <td>27573.0</td>\n",
       "      <td>123449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>111268.0</td>\n",
       "      <td>39346.0</td>\n",
       "      <td>33375.0</td>\n",
       "      <td>186370.0</td>\n",
       "      <td>186370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>142199.0</td>\n",
       "      <td>69935.0</td>\n",
       "      <td>38637.0</td>\n",
       "      <td>33627.0</td>\n",
       "      <td>142199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>123018.0</td>\n",
       "      <td>45784.0</td>\n",
       "      <td>39797.0</td>\n",
       "      <td>211370.0</td>\n",
       "      <td>211370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>160949.0</td>\n",
       "      <td>75776.0</td>\n",
       "      <td>45075.0</td>\n",
       "      <td>40098.0</td>\n",
       "      <td>160949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>134692.0</td>\n",
       "      <td>52221.0</td>\n",
       "      <td>46686.0</td>\n",
       "      <td>236370.0</td>\n",
       "      <td>236370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>179699.0</td>\n",
       "      <td>81200.0</td>\n",
       "      <td>51512.0</td>\n",
       "      <td>46987.0</td>\n",
       "      <td>179699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>146365.0</td>\n",
       "      <td>58659.0</td>\n",
       "      <td>53575.0</td>\n",
       "      <td>261370.0</td>\n",
       "      <td>261370.0</td>\n",
       "      <td>6879.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>198449.0</td>\n",
       "      <td>86623.0</td>\n",
       "      <td>57950.0</td>\n",
       "      <td>53875.0</td>\n",
       "      <td>198449.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>432 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     age  inc_earning  inc_CPP_pension  inc_private_pension  ind_disp_inc  \\\n",
       "0     60          0.0              0.0                  0.0        7956.0   \n",
       "1     60      25000.0              0.0                  0.0       20759.0   \n",
       "2     60      50000.0              0.0                  0.0       36264.0   \n",
       "3     60      75000.0              0.0                  0.0       51643.0   \n",
       "4     60     100000.0              0.0                  0.0       66367.0   \n",
       "5     60     125000.0              0.0                  0.0       79577.0   \n",
       "6     60          0.0           2500.0                  0.0       10356.0   \n",
       "7     60      25000.0           2500.0                  0.0       22546.0   \n",
       "8     60      50000.0           2500.0                  0.0       37837.0   \n",
       "9     60      75000.0           2500.0                  0.0       53215.0   \n",
       "10    60     100000.0           2500.0                  0.0       67724.0   \n",
       "11    60     125000.0           2500.0                  0.0       80890.0   \n",
       "12    60          0.0           5000.0                  0.0       10356.0   \n",
       "13    60      25000.0           5000.0                  0.0       24333.0   \n",
       "14    60      50000.0           5000.0                  0.0       39409.0   \n",
       "15    60      75000.0           5000.0                  0.0       54787.0   \n",
       "16    60     100000.0           5000.0                  0.0       69069.0   \n",
       "17    60     125000.0           5000.0                  0.0       82204.0   \n",
       "18    60          0.0           7500.0                  0.0       10356.0   \n",
       "19    60      25000.0           7500.0                  0.0       26120.0   \n",
       "20    60      50000.0           7500.0                  0.0       40981.0   \n",
       "21    60      75000.0           7500.0                  0.0       56359.0   \n",
       "22    60     100000.0           7500.0                  0.0       70382.0   \n",
       "23    60     125000.0           7500.0                  0.0       83517.0   \n",
       "24    60          0.0          10000.0                  0.0       10356.0   \n",
       "25    60      25000.0          10000.0                  0.0       27862.0   \n",
       "26    60      50000.0          10000.0                  0.0       42553.0   \n",
       "27    60      75000.0          10000.0                  0.0       57931.0   \n",
       "28    60     100000.0          10000.0                  0.0       71696.0   \n",
       "29    60     125000.0          10000.0                  0.0       84831.0   \n",
       "..   ...          ...              ...                  ...           ...   \n",
       "402   65          0.0           2500.0             125000.0       84559.0   \n",
       "403   65      25000.0           2500.0             125000.0       95682.0   \n",
       "404   65      50000.0           2500.0             125000.0      106265.0   \n",
       "405   65      75000.0           2500.0             125000.0      118348.0   \n",
       "406   65     100000.0           2500.0             125000.0      130022.0   \n",
       "407   65     125000.0           2500.0             125000.0      141696.0   \n",
       "408   65          0.0           5000.0             125000.0       85872.0   \n",
       "409   65      25000.0           5000.0             125000.0       96833.0   \n",
       "410   65      50000.0           5000.0             125000.0      107516.0   \n",
       "411   65      75000.0           5000.0             125000.0      119516.0   \n",
       "412   65     100000.0           5000.0             125000.0      131189.0   \n",
       "413   65     125000.0           5000.0             125000.0      142863.0   \n",
       "414   65          0.0           7500.0             125000.0       87186.0   \n",
       "415   65      25000.0           7500.0             125000.0       97984.0   \n",
       "416   65      50000.0           7500.0             125000.0      108767.0   \n",
       "417   65      75000.0           7500.0             125000.0      120683.0   \n",
       "418   65     100000.0           7500.0             125000.0      132357.0   \n",
       "419   65     125000.0           7500.0             125000.0      144031.0   \n",
       "420   65          0.0          10000.0             125000.0       88463.0   \n",
       "421   65      25000.0          10000.0             125000.0       99135.0   \n",
       "422   65      50000.0          10000.0             125000.0      110018.0   \n",
       "423   65      75000.0          10000.0             125000.0      121850.0   \n",
       "424   65     100000.0          10000.0             125000.0      133524.0   \n",
       "425   65     125000.0          10000.0             125000.0      145198.0   \n",
       "426   65          0.0          12500.0             125000.0       89677.0   \n",
       "427   65      25000.0          12500.0             125000.0      100376.0   \n",
       "428   65      50000.0          12500.0             125000.0      111268.0   \n",
       "429   65      75000.0          12500.0             125000.0      123018.0   \n",
       "430   65     100000.0          12500.0             125000.0      134692.0   \n",
       "431   65     125000.0          12500.0             125000.0      146365.0   \n",
       "\n",
       "     prov_inc_tax  fed_inc_tax  QC_NET_inc  QC_Taxable_Inc  OAS_inc  GIS_inc  \\\n",
       "0             0.0          0.0      7956.0             0.0      0.0      0.0   \n",
       "1          1238.0       1341.0     23870.0         23870.0      0.0      0.0   \n",
       "2          5768.0       4457.0     48870.0         48870.0      0.0      0.0   \n",
       "3         10768.0       8687.0     73870.0         73870.0      0.0      0.0   \n",
       "4         16332.0      13400.0     98870.0         98870.0      0.0      0.0   \n",
       "5         22695.0      18828.0    123870.0        123870.0      0.0      0.0   \n",
       "6             0.0          0.0     10356.0          2500.0      0.0      0.0   \n",
       "7          1638.0       1654.0     26370.0         26370.0      0.0      0.0   \n",
       "8          6268.0       4885.0     51370.0         51370.0      0.0      0.0   \n",
       "9         11268.0       9115.0     76370.0         76370.0      0.0      0.0   \n",
       "10        16932.0      13943.0    101370.0        101370.0      0.0      0.0   \n",
       "11        23338.0      19370.0    126370.0        126370.0      0.0      0.0   \n",
       "12            0.0          0.0     10356.0          5000.0      0.0      0.0   \n",
       "13         2038.0       1967.0     28870.0         28870.0      0.0      0.0   \n",
       "14         6768.0       5313.0     53870.0         53870.0      0.0      0.0   \n",
       "15        11768.0       9543.0     78870.0         78870.0      0.0      0.0   \n",
       "16        17545.0      14486.0    103870.0        103870.0      0.0      0.0   \n",
       "17        23982.0      19913.0    128870.0        128870.0      0.0      0.0   \n",
       "18            0.0          0.0     10356.0          7500.0      0.0      0.0   \n",
       "19         2438.0       2280.0     31370.0         31370.0      0.0      0.0   \n",
       "20         7268.0       5741.0     56370.0         56370.0      0.0      0.0   \n",
       "21        12268.0       9971.0     81370.0         81370.0      0.0      0.0   \n",
       "22        18188.0      15028.0    106370.0        106370.0      0.0      0.0   \n",
       "23        24626.0      20456.0    131370.0        131370.0      0.0      0.0   \n",
       "24            0.0          0.0     10356.0         10000.0      0.0      0.0   \n",
       "25         2883.0       2593.0     33870.0         33870.0      0.0      0.0   \n",
       "26         7768.0       6169.0     58870.0         58870.0      0.0      0.0   \n",
       "27        12768.0      10399.0     83870.0         83870.0      0.0      0.0   \n",
       "28        18832.0      15571.0    108870.0        108870.0      0.0      0.0   \n",
       "29        25270.0      20999.0    133870.0        133870.0      0.0      0.0   \n",
       "..            ...          ...         ...             ...      ...      ...   \n",
       "402       23187.0      19754.0    127500.0        127500.0   6879.0      0.0   \n",
       "403       30025.0      25131.0    151370.0        151370.0   6879.0      0.0   \n",
       "404       36771.0      30954.0    176370.0        176370.0   6879.0      0.0   \n",
       "405       43209.0      37042.0    201370.0        201370.0   6879.0      0.0   \n",
       "406       49646.0      43931.0    226370.0        226370.0   6879.0      0.0   \n",
       "407       56084.0      50819.0    251370.0        251370.0   6879.0      0.0   \n",
       "408       23831.0      20297.0    130000.0        130000.0   6879.0      0.0   \n",
       "409       30769.0      25737.0    153870.0        153870.0   6879.0      0.0   \n",
       "410       37415.0      31559.0    178870.0        178870.0   6879.0      0.0   \n",
       "411       43853.0      37731.0    203870.0        203870.0   6879.0      0.0   \n",
       "412       50290.0      44619.0    228870.0        228870.0   6879.0      0.0   \n",
       "413       56728.0      51508.0    253870.0        253870.0   6879.0      0.0   \n",
       "414       24475.0      20839.0    132500.0        132500.0   6879.0      0.0   \n",
       "415       31512.0      26342.0    156370.0        156370.0   6879.0      0.0   \n",
       "416       38059.0      32164.0    181370.0        181370.0   6879.0      0.0   \n",
       "417       44496.0      38420.0    206370.0        206370.0   6879.0      0.0   \n",
       "418       50934.0      45308.0    231370.0        231370.0   6879.0      0.0   \n",
       "419       57371.0      52197.0    256370.0        256370.0   6879.0      0.0   \n",
       "420       25155.0      21382.0    135000.0        135000.0   6879.0      0.0   \n",
       "421       32256.0      26947.0    158870.0        158870.0   6879.0      0.0   \n",
       "422       38703.0      32770.0    183870.0        183870.0   6879.0      0.0   \n",
       "423       45140.0      39108.0    208870.0        208870.0   6879.0      0.0   \n",
       "424       51578.0      45997.0    233870.0        233870.0   6879.0      0.0   \n",
       "425       58015.0      52886.0    258870.0        258870.0   6879.0      0.0   \n",
       "426       25899.0      21925.0    137500.0        137500.0   6879.0      0.0   \n",
       "427       32909.0      27553.0    161370.0        161370.0   6879.0      0.0   \n",
       "428       39346.0      33375.0    186370.0        186370.0   6879.0      0.0   \n",
       "429       45784.0      39797.0    211370.0        211370.0   6879.0      0.0   \n",
       "430       52221.0      46686.0    236370.0        236370.0   6879.0      0.0   \n",
       "431       58659.0      53575.0    261370.0        261370.0   6879.0      0.0   \n",
       "\n",
       "         pinc  paftertax  pro_liab  fed_liab    totinc  \n",
       "0      1074.0     1074.0       0.0       0.0    1074.0  \n",
       "1     20324.0    18578.0     335.0    1410.0   20324.0  \n",
       "2     39074.0    28321.0    5994.0    4758.0   39074.0  \n",
       "3     57824.0    37792.0   10994.0    9037.0   57824.0  \n",
       "4     76574.0    46220.0   16603.0   13750.0   76574.0  \n",
       "5     95324.0    53160.0   22986.0   19178.0   95324.0  \n",
       "6      3449.0     3449.0       0.0       0.0    3449.0  \n",
       "7     22199.0    19740.0     735.0    1723.0   22199.0  \n",
       "8     40949.0    29268.0    6494.0    5186.0   40949.0  \n",
       "9     59699.0    38739.0   11494.0    9465.0   59699.0  \n",
       "10    78449.0    46952.0   17203.0   14293.0   78449.0  \n",
       "11    97199.0    53849.0   23629.0   19720.0   97199.0  \n",
       "12     5324.0     5324.0       0.0       0.0    5324.0  \n",
       "13    24074.0    20902.0    1135.0    2036.0   24074.0  \n",
       "14    42824.0    30215.0    6994.0    5614.0   42824.0  \n",
       "15    61574.0    39686.0   11994.0    9893.0   61574.0  \n",
       "16    80324.0    47652.0   17836.0   14836.0   80324.0  \n",
       "17    99074.0    54537.0   24273.0   20263.0   99074.0  \n",
       "18     7199.0     7199.0       0.0       0.0    7199.0  \n",
       "19    25949.0    22064.0    1535.0    2350.0   25949.0  \n",
       "20    44699.0    31162.0    7494.0    6042.0   44699.0  \n",
       "21    63449.0    40633.0   12494.0   10321.0   63449.0  \n",
       "22    82199.0    48341.0   18479.0   15378.0   82199.0  \n",
       "23   100949.0    55226.0   24917.0   20806.0  100949.0  \n",
       "24     9074.0     9074.0       0.0       0.0    9074.0  \n",
       "25    27824.0    22927.0    2234.0    2663.0   27824.0  \n",
       "26    46574.0    32109.0    7994.0    6470.0   46574.0  \n",
       "27    65324.0    41571.0   13003.0   10749.0   65324.0  \n",
       "28    84074.0    49029.0   19123.0   15921.0   84074.0  \n",
       "29   102824.0    55914.0   25561.0   21349.0  102824.0  \n",
       "..        ...        ...       ...       ...       ...  \n",
       "402   97199.0    54591.0   23187.0   19420.0   97199.0  \n",
       "403  115949.0    61172.0   29625.0   25151.0  115949.0  \n",
       "404  134699.0    67431.0   36062.0   31205.0  134699.0  \n",
       "405  153449.0    73606.0   42500.0   37342.0  153449.0  \n",
       "406  172199.0    79030.0   48937.0   44231.0  172199.0  \n",
       "407  190949.0    84454.0   55375.0   51120.0  190949.0  \n",
       "408   99074.0    55279.0   23831.0   19963.0   99074.0  \n",
       "409  117824.0    61798.0   30269.0   25757.0  117824.0  \n",
       "410  136574.0    68057.0   36706.0   31810.0  136574.0  \n",
       "411  155324.0    74149.0   43144.0   38031.0  155324.0  \n",
       "412  174074.0    79572.0   49581.0   44920.0  174074.0  \n",
       "413  192824.0    84996.0   56019.0   51809.0  192824.0  \n",
       "414  100949.0    55968.0   24475.0   20506.0  100949.0  \n",
       "415  119699.0    62424.0   30912.0   26362.0  119699.0  \n",
       "416  138449.0    68683.0   37350.0   32416.0  138449.0  \n",
       "417  157199.0    74691.0   43787.0   38720.0  157199.0  \n",
       "418  175949.0    80115.0   50225.0   45609.0  175949.0  \n",
       "419  194699.0    85539.0   56662.0   52498.0  194699.0  \n",
       "420  102824.0    56656.0   25119.0   21049.0  102824.0  \n",
       "421  121574.0    63050.0   31556.0   26967.0  121574.0  \n",
       "422  140324.0    69309.0   37994.0   33021.0  140324.0  \n",
       "423  159074.0    75233.0   44431.0   39409.0  159074.0  \n",
       "424  177824.0    80657.0   50869.0   46298.0  177824.0  \n",
       "425  196574.0    86081.0   57306.0   53186.0  196574.0  \n",
       "426  104699.0    57345.0   25762.0   21591.0  104699.0  \n",
       "427  123449.0    63676.0   32200.0   27573.0  123449.0  \n",
       "428  142199.0    69935.0   38637.0   33627.0  142199.0  \n",
       "429  160949.0    75776.0   45075.0   40098.0  160949.0  \n",
       "430  179699.0    81200.0   51512.0   46987.0  179699.0  \n",
       "431  198449.0    86623.0   57950.0   53875.0  198449.0  \n",
       "\n",
       "[432 rows x 16 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comparaison"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " Exemple de choix des variables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "comparaison_select = pd.concat([simtax_fortran_out[['age', 'inc_earning', 'inc_CPP_pension', 'inc_private_pension',\n",
    "       'ind_disp_inc', 'prov_inc_tax', 'fed_inc_tax']],simtax_py_out], axis=1)\n",
    "comparaison_select = round(comparaison_select)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>age</th>\n",
       "      <th>inc_earning</th>\n",
       "      <th>inc_CPP_pension</th>\n",
       "      <th>inc_private_pension</th>\n",
       "      <th>ind_disp_inc</th>\n",
       "      <th>prov_inc_tax</th>\n",
       "      <th>fed_inc_tax</th>\n",
       "      <th>pinc</th>\n",
       "      <th>paftertax</th>\n",
       "      <th>pro_liab</th>\n",
       "      <th>fed_liab</th>\n",
       "      <th>totinc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7956.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>1074.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20759.0</td>\n",
       "      <td>1238.0</td>\n",
       "      <td>1341.0</td>\n",
       "      <td>20324.0</td>\n",
       "      <td>18578.0</td>\n",
       "      <td>335.0</td>\n",
       "      <td>1410.0</td>\n",
       "      <td>20324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>36264.0</td>\n",
       "      <td>5768.0</td>\n",
       "      <td>4457.0</td>\n",
       "      <td>39074.0</td>\n",
       "      <td>28321.0</td>\n",
       "      <td>5994.0</td>\n",
       "      <td>4758.0</td>\n",
       "      <td>39074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51643.0</td>\n",
       "      <td>10768.0</td>\n",
       "      <td>8687.0</td>\n",
       "      <td>57824.0</td>\n",
       "      <td>37792.0</td>\n",
       "      <td>10994.0</td>\n",
       "      <td>9037.0</td>\n",
       "      <td>57824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>66367.0</td>\n",
       "      <td>16332.0</td>\n",
       "      <td>13400.0</td>\n",
       "      <td>76574.0</td>\n",
       "      <td>46220.0</td>\n",
       "      <td>16603.0</td>\n",
       "      <td>13750.0</td>\n",
       "      <td>76574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79577.0</td>\n",
       "      <td>22695.0</td>\n",
       "      <td>18828.0</td>\n",
       "      <td>95324.0</td>\n",
       "      <td>53160.0</td>\n",
       "      <td>22986.0</td>\n",
       "      <td>19178.0</td>\n",
       "      <td>95324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3449.0</td>\n",
       "      <td>3449.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>22546.0</td>\n",
       "      <td>1638.0</td>\n",
       "      <td>1654.0</td>\n",
       "      <td>22199.0</td>\n",
       "      <td>19740.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>1723.0</td>\n",
       "      <td>22199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>37837.0</td>\n",
       "      <td>6268.0</td>\n",
       "      <td>4885.0</td>\n",
       "      <td>40949.0</td>\n",
       "      <td>29268.0</td>\n",
       "      <td>6494.0</td>\n",
       "      <td>5186.0</td>\n",
       "      <td>40949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53215.0</td>\n",
       "      <td>11268.0</td>\n",
       "      <td>9115.0</td>\n",
       "      <td>59699.0</td>\n",
       "      <td>38739.0</td>\n",
       "      <td>11494.0</td>\n",
       "      <td>9465.0</td>\n",
       "      <td>59699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>67724.0</td>\n",
       "      <td>16932.0</td>\n",
       "      <td>13943.0</td>\n",
       "      <td>78449.0</td>\n",
       "      <td>46952.0</td>\n",
       "      <td>17203.0</td>\n",
       "      <td>14293.0</td>\n",
       "      <td>78449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80890.0</td>\n",
       "      <td>23338.0</td>\n",
       "      <td>19370.0</td>\n",
       "      <td>97199.0</td>\n",
       "      <td>53849.0</td>\n",
       "      <td>23629.0</td>\n",
       "      <td>19720.0</td>\n",
       "      <td>97199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5324.0</td>\n",
       "      <td>5324.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24333.0</td>\n",
       "      <td>2038.0</td>\n",
       "      <td>1967.0</td>\n",
       "      <td>24074.0</td>\n",
       "      <td>20902.0</td>\n",
       "      <td>1135.0</td>\n",
       "      <td>2036.0</td>\n",
       "      <td>24074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39409.0</td>\n",
       "      <td>6768.0</td>\n",
       "      <td>5313.0</td>\n",
       "      <td>42824.0</td>\n",
       "      <td>30215.0</td>\n",
       "      <td>6994.0</td>\n",
       "      <td>5614.0</td>\n",
       "      <td>42824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54787.0</td>\n",
       "      <td>11768.0</td>\n",
       "      <td>9543.0</td>\n",
       "      <td>61574.0</td>\n",
       "      <td>39686.0</td>\n",
       "      <td>11994.0</td>\n",
       "      <td>9893.0</td>\n",
       "      <td>61574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>69069.0</td>\n",
       "      <td>17545.0</td>\n",
       "      <td>14486.0</td>\n",
       "      <td>80324.0</td>\n",
       "      <td>47652.0</td>\n",
       "      <td>17836.0</td>\n",
       "      <td>14836.0</td>\n",
       "      <td>80324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>82204.0</td>\n",
       "      <td>23982.0</td>\n",
       "      <td>19913.0</td>\n",
       "      <td>99074.0</td>\n",
       "      <td>54537.0</td>\n",
       "      <td>24273.0</td>\n",
       "      <td>20263.0</td>\n",
       "      <td>99074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>7199.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26120.0</td>\n",
       "      <td>2438.0</td>\n",
       "      <td>2280.0</td>\n",
       "      <td>25949.0</td>\n",
       "      <td>22064.0</td>\n",
       "      <td>1535.0</td>\n",
       "      <td>2350.0</td>\n",
       "      <td>25949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40981.0</td>\n",
       "      <td>7268.0</td>\n",
       "      <td>5741.0</td>\n",
       "      <td>44699.0</td>\n",
       "      <td>31162.0</td>\n",
       "      <td>7494.0</td>\n",
       "      <td>6042.0</td>\n",
       "      <td>44699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>56359.0</td>\n",
       "      <td>12268.0</td>\n",
       "      <td>9971.0</td>\n",
       "      <td>63449.0</td>\n",
       "      <td>40633.0</td>\n",
       "      <td>12494.0</td>\n",
       "      <td>10321.0</td>\n",
       "      <td>63449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>70382.0</td>\n",
       "      <td>18188.0</td>\n",
       "      <td>15028.0</td>\n",
       "      <td>82199.0</td>\n",
       "      <td>48341.0</td>\n",
       "      <td>18479.0</td>\n",
       "      <td>15378.0</td>\n",
       "      <td>82199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>83517.0</td>\n",
       "      <td>24626.0</td>\n",
       "      <td>20456.0</td>\n",
       "      <td>100949.0</td>\n",
       "      <td>55226.0</td>\n",
       "      <td>24917.0</td>\n",
       "      <td>20806.0</td>\n",
       "      <td>100949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9074.0</td>\n",
       "      <td>9074.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>60</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27862.0</td>\n",
       "      <td>2883.0</td>\n",
       "      <td>2593.0</td>\n",
       "      <td>27824.0</td>\n",
       "      <td>22927.0</td>\n",
       "      <td>2234.0</td>\n",
       "      <td>2663.0</td>\n",
       "      <td>27824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>60</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>42553.0</td>\n",
       "      <td>7768.0</td>\n",
       "      <td>6169.0</td>\n",
       "      <td>46574.0</td>\n",
       "      <td>32109.0</td>\n",
       "      <td>7994.0</td>\n",
       "      <td>6470.0</td>\n",
       "      <td>46574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>60</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57931.0</td>\n",
       "      <td>12768.0</td>\n",
       "      <td>10399.0</td>\n",
       "      <td>65324.0</td>\n",
       "      <td>41571.0</td>\n",
       "      <td>13003.0</td>\n",
       "      <td>10749.0</td>\n",
       "      <td>65324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>60</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>71696.0</td>\n",
       "      <td>18832.0</td>\n",
       "      <td>15571.0</td>\n",
       "      <td>84074.0</td>\n",
       "      <td>49029.0</td>\n",
       "      <td>19123.0</td>\n",
       "      <td>15921.0</td>\n",
       "      <td>84074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>60</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>84831.0</td>\n",
       "      <td>25270.0</td>\n",
       "      <td>20999.0</td>\n",
       "      <td>102824.0</td>\n",
       "      <td>55914.0</td>\n",
       "      <td>25561.0</td>\n",
       "      <td>21349.0</td>\n",
       "      <td>102824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>84559.0</td>\n",
       "      <td>23187.0</td>\n",
       "      <td>19754.0</td>\n",
       "      <td>97199.0</td>\n",
       "      <td>54591.0</td>\n",
       "      <td>23187.0</td>\n",
       "      <td>19420.0</td>\n",
       "      <td>97199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>95682.0</td>\n",
       "      <td>30025.0</td>\n",
       "      <td>25131.0</td>\n",
       "      <td>115949.0</td>\n",
       "      <td>61172.0</td>\n",
       "      <td>29625.0</td>\n",
       "      <td>25151.0</td>\n",
       "      <td>115949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>106265.0</td>\n",
       "      <td>36771.0</td>\n",
       "      <td>30954.0</td>\n",
       "      <td>134699.0</td>\n",
       "      <td>67431.0</td>\n",
       "      <td>36062.0</td>\n",
       "      <td>31205.0</td>\n",
       "      <td>134699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>118348.0</td>\n",
       "      <td>43209.0</td>\n",
       "      <td>37042.0</td>\n",
       "      <td>153449.0</td>\n",
       "      <td>73606.0</td>\n",
       "      <td>42500.0</td>\n",
       "      <td>37342.0</td>\n",
       "      <td>153449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>130022.0</td>\n",
       "      <td>49646.0</td>\n",
       "      <td>43931.0</td>\n",
       "      <td>172199.0</td>\n",
       "      <td>79030.0</td>\n",
       "      <td>48937.0</td>\n",
       "      <td>44231.0</td>\n",
       "      <td>172199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>141696.0</td>\n",
       "      <td>56084.0</td>\n",
       "      <td>50819.0</td>\n",
       "      <td>190949.0</td>\n",
       "      <td>84454.0</td>\n",
       "      <td>55375.0</td>\n",
       "      <td>51120.0</td>\n",
       "      <td>190949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>85872.0</td>\n",
       "      <td>23831.0</td>\n",
       "      <td>20297.0</td>\n",
       "      <td>99074.0</td>\n",
       "      <td>55279.0</td>\n",
       "      <td>23831.0</td>\n",
       "      <td>19963.0</td>\n",
       "      <td>99074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>96833.0</td>\n",
       "      <td>30769.0</td>\n",
       "      <td>25737.0</td>\n",
       "      <td>117824.0</td>\n",
       "      <td>61798.0</td>\n",
       "      <td>30269.0</td>\n",
       "      <td>25757.0</td>\n",
       "      <td>117824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>107516.0</td>\n",
       "      <td>37415.0</td>\n",
       "      <td>31559.0</td>\n",
       "      <td>136574.0</td>\n",
       "      <td>68057.0</td>\n",
       "      <td>36706.0</td>\n",
       "      <td>31810.0</td>\n",
       "      <td>136574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>119516.0</td>\n",
       "      <td>43853.0</td>\n",
       "      <td>37731.0</td>\n",
       "      <td>155324.0</td>\n",
       "      <td>74149.0</td>\n",
       "      <td>43144.0</td>\n",
       "      <td>38031.0</td>\n",
       "      <td>155324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>131189.0</td>\n",
       "      <td>50290.0</td>\n",
       "      <td>44619.0</td>\n",
       "      <td>174074.0</td>\n",
       "      <td>79572.0</td>\n",
       "      <td>49581.0</td>\n",
       "      <td>44920.0</td>\n",
       "      <td>174074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>142863.0</td>\n",
       "      <td>56728.0</td>\n",
       "      <td>51508.0</td>\n",
       "      <td>192824.0</td>\n",
       "      <td>84996.0</td>\n",
       "      <td>56019.0</td>\n",
       "      <td>51809.0</td>\n",
       "      <td>192824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>87186.0</td>\n",
       "      <td>24475.0</td>\n",
       "      <td>20839.0</td>\n",
       "      <td>100949.0</td>\n",
       "      <td>55968.0</td>\n",
       "      <td>24475.0</td>\n",
       "      <td>20506.0</td>\n",
       "      <td>100949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>97984.0</td>\n",
       "      <td>31512.0</td>\n",
       "      <td>26342.0</td>\n",
       "      <td>119699.0</td>\n",
       "      <td>62424.0</td>\n",
       "      <td>30912.0</td>\n",
       "      <td>26362.0</td>\n",
       "      <td>119699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>108767.0</td>\n",
       "      <td>38059.0</td>\n",
       "      <td>32164.0</td>\n",
       "      <td>138449.0</td>\n",
       "      <td>68683.0</td>\n",
       "      <td>37350.0</td>\n",
       "      <td>32416.0</td>\n",
       "      <td>138449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>120683.0</td>\n",
       "      <td>44496.0</td>\n",
       "      <td>38420.0</td>\n",
       "      <td>157199.0</td>\n",
       "      <td>74691.0</td>\n",
       "      <td>43787.0</td>\n",
       "      <td>38720.0</td>\n",
       "      <td>157199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>132357.0</td>\n",
       "      <td>50934.0</td>\n",
       "      <td>45308.0</td>\n",
       "      <td>175949.0</td>\n",
       "      <td>80115.0</td>\n",
       "      <td>50225.0</td>\n",
       "      <td>45609.0</td>\n",
       "      <td>175949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>144031.0</td>\n",
       "      <td>57371.0</td>\n",
       "      <td>52197.0</td>\n",
       "      <td>194699.0</td>\n",
       "      <td>85539.0</td>\n",
       "      <td>56662.0</td>\n",
       "      <td>52498.0</td>\n",
       "      <td>194699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>88463.0</td>\n",
       "      <td>25155.0</td>\n",
       "      <td>21382.0</td>\n",
       "      <td>102824.0</td>\n",
       "      <td>56656.0</td>\n",
       "      <td>25119.0</td>\n",
       "      <td>21049.0</td>\n",
       "      <td>102824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>99135.0</td>\n",
       "      <td>32256.0</td>\n",
       "      <td>26947.0</td>\n",
       "      <td>121574.0</td>\n",
       "      <td>63050.0</td>\n",
       "      <td>31556.0</td>\n",
       "      <td>26967.0</td>\n",
       "      <td>121574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>110018.0</td>\n",
       "      <td>38703.0</td>\n",
       "      <td>32770.0</td>\n",
       "      <td>140324.0</td>\n",
       "      <td>69309.0</td>\n",
       "      <td>37994.0</td>\n",
       "      <td>33021.0</td>\n",
       "      <td>140324.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>121850.0</td>\n",
       "      <td>45140.0</td>\n",
       "      <td>39108.0</td>\n",
       "      <td>159074.0</td>\n",
       "      <td>75233.0</td>\n",
       "      <td>44431.0</td>\n",
       "      <td>39409.0</td>\n",
       "      <td>159074.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>133524.0</td>\n",
       "      <td>51578.0</td>\n",
       "      <td>45997.0</td>\n",
       "      <td>177824.0</td>\n",
       "      <td>80657.0</td>\n",
       "      <td>50869.0</td>\n",
       "      <td>46298.0</td>\n",
       "      <td>177824.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>145198.0</td>\n",
       "      <td>58015.0</td>\n",
       "      <td>52886.0</td>\n",
       "      <td>196574.0</td>\n",
       "      <td>86081.0</td>\n",
       "      <td>57306.0</td>\n",
       "      <td>53186.0</td>\n",
       "      <td>196574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>65</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>89677.0</td>\n",
       "      <td>25899.0</td>\n",
       "      <td>21925.0</td>\n",
       "      <td>104699.0</td>\n",
       "      <td>57345.0</td>\n",
       "      <td>25762.0</td>\n",
       "      <td>21591.0</td>\n",
       "      <td>104699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>65</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>100376.0</td>\n",
       "      <td>32909.0</td>\n",
       "      <td>27553.0</td>\n",
       "      <td>123449.0</td>\n",
       "      <td>63676.0</td>\n",
       "      <td>32200.0</td>\n",
       "      <td>27573.0</td>\n",
       "      <td>123449.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>65</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>111268.0</td>\n",
       "      <td>39346.0</td>\n",
       "      <td>33375.0</td>\n",
       "      <td>142199.0</td>\n",
       "      <td>69935.0</td>\n",
       "      <td>38637.0</td>\n",
       "      <td>33627.0</td>\n",
       "      <td>142199.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>65</td>\n",
       "      <td>75000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>123018.0</td>\n",
       "      <td>45784.0</td>\n",
       "      <td>39797.0</td>\n",
       "      <td>160949.0</td>\n",
       "      <td>75776.0</td>\n",
       "      <td>45075.0</td>\n",
       "      <td>40098.0</td>\n",
       "      <td>160949.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>65</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>134692.0</td>\n",
       "      <td>52221.0</td>\n",
       "      <td>46686.0</td>\n",
       "      <td>179699.0</td>\n",
       "      <td>81200.0</td>\n",
       "      <td>51512.0</td>\n",
       "      <td>46987.0</td>\n",
       "      <td>179699.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>65</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>12500.0</td>\n",
       "      <td>125000.0</td>\n",
       "      <td>146365.0</td>\n",
       "      <td>58659.0</td>\n",
       "      <td>53575.0</td>\n",
       "      <td>198449.0</td>\n",
       "      <td>86623.0</td>\n",
       "      <td>57950.0</td>\n",
       "      <td>53875.0</td>\n",
       "      <td>198449.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>432 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     age  inc_earning  inc_CPP_pension  inc_private_pension  ind_disp_inc  \\\n",
       "0     60          0.0              0.0                  0.0        7956.0   \n",
       "1     60      25000.0              0.0                  0.0       20759.0   \n",
       "2     60      50000.0              0.0                  0.0       36264.0   \n",
       "3     60      75000.0              0.0                  0.0       51643.0   \n",
       "4     60     100000.0              0.0                  0.0       66367.0   \n",
       "5     60     125000.0              0.0                  0.0       79577.0   \n",
       "6     60          0.0           2500.0                  0.0       10356.0   \n",
       "7     60      25000.0           2500.0                  0.0       22546.0   \n",
       "8     60      50000.0           2500.0                  0.0       37837.0   \n",
       "9     60      75000.0           2500.0                  0.0       53215.0   \n",
       "10    60     100000.0           2500.0                  0.0       67724.0   \n",
       "11    60     125000.0           2500.0                  0.0       80890.0   \n",
       "12    60          0.0           5000.0                  0.0       10356.0   \n",
       "13    60      25000.0           5000.0                  0.0       24333.0   \n",
       "14    60      50000.0           5000.0                  0.0       39409.0   \n",
       "15    60      75000.0           5000.0                  0.0       54787.0   \n",
       "16    60     100000.0           5000.0                  0.0       69069.0   \n",
       "17    60     125000.0           5000.0                  0.0       82204.0   \n",
       "18    60          0.0           7500.0                  0.0       10356.0   \n",
       "19    60      25000.0           7500.0                  0.0       26120.0   \n",
       "20    60      50000.0           7500.0                  0.0       40981.0   \n",
       "21    60      75000.0           7500.0                  0.0       56359.0   \n",
       "22    60     100000.0           7500.0                  0.0       70382.0   \n",
       "23    60     125000.0           7500.0                  0.0       83517.0   \n",
       "24    60          0.0          10000.0                  0.0       10356.0   \n",
       "25    60      25000.0          10000.0                  0.0       27862.0   \n",
       "26    60      50000.0          10000.0                  0.0       42553.0   \n",
       "27    60      75000.0          10000.0                  0.0       57931.0   \n",
       "28    60     100000.0          10000.0                  0.0       71696.0   \n",
       "29    60     125000.0          10000.0                  0.0       84831.0   \n",
       "..   ...          ...              ...                  ...           ...   \n",
       "402   65          0.0           2500.0             125000.0       84559.0   \n",
       "403   65      25000.0           2500.0             125000.0       95682.0   \n",
       "404   65      50000.0           2500.0             125000.0      106265.0   \n",
       "405   65      75000.0           2500.0             125000.0      118348.0   \n",
       "406   65     100000.0           2500.0             125000.0      130022.0   \n",
       "407   65     125000.0           2500.0             125000.0      141696.0   \n",
       "408   65          0.0           5000.0             125000.0       85872.0   \n",
       "409   65      25000.0           5000.0             125000.0       96833.0   \n",
       "410   65      50000.0           5000.0             125000.0      107516.0   \n",
       "411   65      75000.0           5000.0             125000.0      119516.0   \n",
       "412   65     100000.0           5000.0             125000.0      131189.0   \n",
       "413   65     125000.0           5000.0             125000.0      142863.0   \n",
       "414   65          0.0           7500.0             125000.0       87186.0   \n",
       "415   65      25000.0           7500.0             125000.0       97984.0   \n",
       "416   65      50000.0           7500.0             125000.0      108767.0   \n",
       "417   65      75000.0           7500.0             125000.0      120683.0   \n",
       "418   65     100000.0           7500.0             125000.0      132357.0   \n",
       "419   65     125000.0           7500.0             125000.0      144031.0   \n",
       "420   65          0.0          10000.0             125000.0       88463.0   \n",
       "421   65      25000.0          10000.0             125000.0       99135.0   \n",
       "422   65      50000.0          10000.0             125000.0      110018.0   \n",
       "423   65      75000.0          10000.0             125000.0      121850.0   \n",
       "424   65     100000.0          10000.0             125000.0      133524.0   \n",
       "425   65     125000.0          10000.0             125000.0      145198.0   \n",
       "426   65          0.0          12500.0             125000.0       89677.0   \n",
       "427   65      25000.0          12500.0             125000.0      100376.0   \n",
       "428   65      50000.0          12500.0             125000.0      111268.0   \n",
       "429   65      75000.0          12500.0             125000.0      123018.0   \n",
       "430   65     100000.0          12500.0             125000.0      134692.0   \n",
       "431   65     125000.0          12500.0             125000.0      146365.0   \n",
       "\n",
       "     prov_inc_tax  fed_inc_tax      pinc  paftertax  pro_liab  fed_liab  \\\n",
       "0             0.0          0.0    1074.0     1074.0       0.0       0.0   \n",
       "1          1238.0       1341.0   20324.0    18578.0     335.0    1410.0   \n",
       "2          5768.0       4457.0   39074.0    28321.0    5994.0    4758.0   \n",
       "3         10768.0       8687.0   57824.0    37792.0   10994.0    9037.0   \n",
       "4         16332.0      13400.0   76574.0    46220.0   16603.0   13750.0   \n",
       "5         22695.0      18828.0   95324.0    53160.0   22986.0   19178.0   \n",
       "6             0.0          0.0    3449.0     3449.0       0.0       0.0   \n",
       "7          1638.0       1654.0   22199.0    19740.0     735.0    1723.0   \n",
       "8          6268.0       4885.0   40949.0    29268.0    6494.0    5186.0   \n",
       "9         11268.0       9115.0   59699.0    38739.0   11494.0    9465.0   \n",
       "10        16932.0      13943.0   78449.0    46952.0   17203.0   14293.0   \n",
       "11        23338.0      19370.0   97199.0    53849.0   23629.0   19720.0   \n",
       "12            0.0          0.0    5324.0     5324.0       0.0       0.0   \n",
       "13         2038.0       1967.0   24074.0    20902.0    1135.0    2036.0   \n",
       "14         6768.0       5313.0   42824.0    30215.0    6994.0    5614.0   \n",
       "15        11768.0       9543.0   61574.0    39686.0   11994.0    9893.0   \n",
       "16        17545.0      14486.0   80324.0    47652.0   17836.0   14836.0   \n",
       "17        23982.0      19913.0   99074.0    54537.0   24273.0   20263.0   \n",
       "18            0.0          0.0    7199.0     7199.0       0.0       0.0   \n",
       "19         2438.0       2280.0   25949.0    22064.0    1535.0    2350.0   \n",
       "20         7268.0       5741.0   44699.0    31162.0    7494.0    6042.0   \n",
       "21        12268.0       9971.0   63449.0    40633.0   12494.0   10321.0   \n",
       "22        18188.0      15028.0   82199.0    48341.0   18479.0   15378.0   \n",
       "23        24626.0      20456.0  100949.0    55226.0   24917.0   20806.0   \n",
       "24            0.0          0.0    9074.0     9074.0       0.0       0.0   \n",
       "25         2883.0       2593.0   27824.0    22927.0    2234.0    2663.0   \n",
       "26         7768.0       6169.0   46574.0    32109.0    7994.0    6470.0   \n",
       "27        12768.0      10399.0   65324.0    41571.0   13003.0   10749.0   \n",
       "28        18832.0      15571.0   84074.0    49029.0   19123.0   15921.0   \n",
       "29        25270.0      20999.0  102824.0    55914.0   25561.0   21349.0   \n",
       "..            ...          ...       ...        ...       ...       ...   \n",
       "402       23187.0      19754.0   97199.0    54591.0   23187.0   19420.0   \n",
       "403       30025.0      25131.0  115949.0    61172.0   29625.0   25151.0   \n",
       "404       36771.0      30954.0  134699.0    67431.0   36062.0   31205.0   \n",
       "405       43209.0      37042.0  153449.0    73606.0   42500.0   37342.0   \n",
       "406       49646.0      43931.0  172199.0    79030.0   48937.0   44231.0   \n",
       "407       56084.0      50819.0  190949.0    84454.0   55375.0   51120.0   \n",
       "408       23831.0      20297.0   99074.0    55279.0   23831.0   19963.0   \n",
       "409       30769.0      25737.0  117824.0    61798.0   30269.0   25757.0   \n",
       "410       37415.0      31559.0  136574.0    68057.0   36706.0   31810.0   \n",
       "411       43853.0      37731.0  155324.0    74149.0   43144.0   38031.0   \n",
       "412       50290.0      44619.0  174074.0    79572.0   49581.0   44920.0   \n",
       "413       56728.0      51508.0  192824.0    84996.0   56019.0   51809.0   \n",
       "414       24475.0      20839.0  100949.0    55968.0   24475.0   20506.0   \n",
       "415       31512.0      26342.0  119699.0    62424.0   30912.0   26362.0   \n",
       "416       38059.0      32164.0  138449.0    68683.0   37350.0   32416.0   \n",
       "417       44496.0      38420.0  157199.0    74691.0   43787.0   38720.0   \n",
       "418       50934.0      45308.0  175949.0    80115.0   50225.0   45609.0   \n",
       "419       57371.0      52197.0  194699.0    85539.0   56662.0   52498.0   \n",
       "420       25155.0      21382.0  102824.0    56656.0   25119.0   21049.0   \n",
       "421       32256.0      26947.0  121574.0    63050.0   31556.0   26967.0   \n",
       "422       38703.0      32770.0  140324.0    69309.0   37994.0   33021.0   \n",
       "423       45140.0      39108.0  159074.0    75233.0   44431.0   39409.0   \n",
       "424       51578.0      45997.0  177824.0    80657.0   50869.0   46298.0   \n",
       "425       58015.0      52886.0  196574.0    86081.0   57306.0   53186.0   \n",
       "426       25899.0      21925.0  104699.0    57345.0   25762.0   21591.0   \n",
       "427       32909.0      27553.0  123449.0    63676.0   32200.0   27573.0   \n",
       "428       39346.0      33375.0  142199.0    69935.0   38637.0   33627.0   \n",
       "429       45784.0      39797.0  160949.0    75776.0   45075.0   40098.0   \n",
       "430       52221.0      46686.0  179699.0    81200.0   51512.0   46987.0   \n",
       "431       58659.0      53575.0  198449.0    86623.0   57950.0   53875.0   \n",
       "\n",
       "       totinc  \n",
       "0      1074.0  \n",
       "1     20324.0  \n",
       "2     39074.0  \n",
       "3     57824.0  \n",
       "4     76574.0  \n",
       "5     95324.0  \n",
       "6      3449.0  \n",
       "7     22199.0  \n",
       "8     40949.0  \n",
       "9     59699.0  \n",
       "10    78449.0  \n",
       "11    97199.0  \n",
       "12     5324.0  \n",
       "13    24074.0  \n",
       "14    42824.0  \n",
       "15    61574.0  \n",
       "16    80324.0  \n",
       "17    99074.0  \n",
       "18     7199.0  \n",
       "19    25949.0  \n",
       "20    44699.0  \n",
       "21    63449.0  \n",
       "22    82199.0  \n",
       "23   100949.0  \n",
       "24     9074.0  \n",
       "25    27824.0  \n",
       "26    46574.0  \n",
       "27    65324.0  \n",
       "28    84074.0  \n",
       "29   102824.0  \n",
       "..        ...  \n",
       "402   97199.0  \n",
       "403  115949.0  \n",
       "404  134699.0  \n",
       "405  153449.0  \n",
       "406  172199.0  \n",
       "407  190949.0  \n",
       "408   99074.0  \n",
       "409  117824.0  \n",
       "410  136574.0  \n",
       "411  155324.0  \n",
       "412  174074.0  \n",
       "413  192824.0  \n",
       "414  100949.0  \n",
       "415  119699.0  \n",
       "416  138449.0  \n",
       "417  157199.0  \n",
       "418  175949.0  \n",
       "419  194699.0  \n",
       "420  102824.0  \n",
       "421  121574.0  \n",
       "422  140324.0  \n",
       "423  159074.0  \n",
       "424  177824.0  \n",
       "425  196574.0  \n",
       "426  104699.0  \n",
       "427  123449.0  \n",
       "428  142199.0  \n",
       "429  160949.0  \n",
       "430  179699.0  \n",
       "431  198449.0  \n",
       "\n",
       "[432 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "comparaison_select"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
